Storing a value from a form to auto populate a field in another form

[bomich]

I have made a form (form 1) that searches for and displays a record from table 1 (which holds information on a process and a hyperlink to work instructions etc..)



I then have a button on form 1 which opens a data entry form (form 2) to record that the process has been carried out in table 2 (with fields like process ref, operator name, date etc..)

I want to be able to store the value of the process ref field (the primary key in table/form 1) and automatically enter this value into form 2 when it is opened using the button.

I think it needs some code to store a value or string on the 'on click' event of the button (form 1) and then a line in the 'on open' of form 2 to make form 2 process ref equal to the stored value...

I'm a real vba noob so I don't really know where to start.

Somebody help please!!?

[bomich]

I have tried this:

Private Sub button_Click()


DoCmd.OpenForm "Form 2", , , , acAdd, acDialog
Forms![Form 1]![Process ref] = Me.Process_Ref


End Sub


It doesn't work but I believe it should..?!

[bomich]

Solved it!!

Me.Process_Ref = Forms![Form 1]![Process ref]

Was correct but it needed to go in the on load event of form 2...!

Thanks For all your help..