Hi,
I have a table called mainTable. two fields of this table are SNO which is text and Relation which is also text.
there are more than 10 fields in this table.
i made a small form called frm_Check with only two fields SNO and Relation using mainTable.
now when i enter values in SNO and in Relation field and after i exit from relation field i want to run an event which should check for SNO and Relation field values in the mainTable. If the values SNO and Relation of frm_Check already exists in mainTable's fields SNO and Relation then an msgBox should appear and the values should not store in table mainTable. what should i do to get this? please tell me.