Hi, How to retrieve records from one form to other,here the second form is different ,that is ,its not opened from the first form.but these two forms uses the same table.Can anybody give me the solution.
1) Here,the records entered in first form(Form1) should be auto populated in second form when we select field1 in second form(Form2). 2) Say for example,if we select field1 in form2,the other fields (field2,3,4,&5)should be defaulted automatically.It should take records from form1. 3) In this case,Fields used in both the forms are same and we have fields1 & 2 are from table1;fields 3 & 4 are from table2 and fields 5 from table3. 4) Here these two forms are different Regards, Subasthri. [Non-text portions of this message have been removed]