filling a field from field in previous form

[lloydmav]

I have two forms. The first form contains fields from a table. There is an add record button to add the record. One of the fields in the first form is called (Base unit of measure). The same commandbutton will, once the record has been added, open the second form. The first field on the second form is also (Base unit of measure) and so I need it to be generated from the field from the previous form. I've used code from a previous post to do it but it doesn't work, I don't get a value in the field!


Here is my code
Me.Text18 = Forms!BasicData1![Base unit of measure]

I've tried to attach this code to a button on the second form and it didn't work and when I attached it to the OpenForm event a error message said "the OpenForm action was cancelled".

I'm sure it must be easy to do but I would really appreciate any help

THANKS

 

[Rich]

Set the value of the second form from the first, save the record first

 

[lloydmav]

Can't believe I missed that! Too many hours in front of screen!

THANKS