passing value from one form to another

[ekta]

Hi:

I have two tables, table1 and table2, that have a one to one relationship and I have two forms based on these two tables. Lets say form1(table1) and form2(table2). Right now user goes to form1 and click on a button to go form2. I want to pass a value of a field on form1 to a field on form2. I tried forms!form1!fieldname and that worked fine. But the problem is that I have 3 forms based on table1 with different names and all these forms have a button to open form2. Now either I make 3 different forms based on table2 but I don't want to do that. Is there any other way of doing this? I hope I din't confuse anyone.

Thanks,

Ekta

 

[RichO]

How about using a public variable. Write a piece of code to store the field value in the public variable when the command button is clicked. Then you can retrieve that value from Form 2.