Hi Experts Around the World. I made a table called mainTable, two fields of this table one is SNO and other is Relation are text data types. SNO and Relation can be any string values. Relation stores value from a combo fox on form called mainForm, this form is based on mainTable. Relation values can be "Self", "Wife", "Son", "Daughter", "Mother", "Father", which can be selected from combo box. I made a query qryMainTable based on mainTable, this query returns SNO and Relation values if Date value = Is Null.
Now i made a form in design view called frmCheck. I took two unbound text boxes one is SNO and other is Relation with a command button. On click this command button, the values in text boxes should check values in qryMainTable. If frmCheck's SNO found in qryMainTable's SNO and Relation of frmCheck= "Self", then a message displays "Entry Exist" and the text boxes should be cleared. If frmCheck's SNO found in qryMainTable's SNO and Relation of frmCheck= other than "Self", then a frmMainForm Should open with SNO and Relation values as entered in unbound text boxes of frmCheck and these values should be stored in table mainTable.
All my project based on test values before insertion. This will really give me a breakthrough if i got this solution. I will be grateful if a help is provided to me at this problem. Thanking all of you.
Mohammad Faisal