copying a field between two forms

[martinrobson]

Hi.

Please can someone help?

I have 2 forms, i would like an ID from form 1 to be copied across to form 2 when it is opened. The ID is generated by an algorithm.

At the moment i have some sql which will search the table to find the last id which was generated and populate the field with that value, however this could have problems if there is more than one user using the app'.

Is there a way of getting the id from form 1 to be displayed on form 2?

Thanks in advance for helping
Martin

 

[koresnordic]

Is the second form opened for additions only? Is the first form still open when you open the second?
If yes to both, then create a new text box. Set the control data to be the ID field in your second table. If you are not using a second table, then have this equal the field on your main table. Now change the default value to be "=[first form name]![field name]".



Graham

 

[martinrobson]

Cheers Graham that worked a treat, fantastic, i can do away with the sql.

Thanks again.