Copy a field from a main form to a secondary form that is selected from the main form

[MIEUCHRE]

I have a main form [Employee Work Form] that contains a field that is an identification number of the employee using the form. They must enter that number to open the form and it is placed in a field [HRMN] on that form. From there the employee can select 1 of three other forms they will need to fill out. I want the [HRMN] field to carry over into the [HRMN NO] field on any of these three forms they open. I understand I will have to work on each form seperately but if I can get one to work I can get the other two to work. One form is [Employee New CPS Entry Form]. I have tried several things and cannot get that number to be copied to the second form. Here is an example of the code I used for an event procedure on the second form upon open:



DoCmd.OpenForm "Employee Work Frm", acNormal
DoCmd.GoToRecord , , acNewRec
Forms![Employee Work Frm].[HRMN].Value = Me.[Hrmn No]

Nothing happens.

I have tried this in the on click field of the second form:

Forms![Employee Work Frm].[HRMN].Value = Me.[HRMN NO]

I get a message access cannot find the form 'Employee work Frm'. Can someone help me I am running out of options and time.

[Bob Fitz]

Try:
DoCmd.OpenForm "Employee Work Frm", , , , , , Me.HRMN
to open the new form. In the forms On Open or On Load event try
Me.HRMN = Me.OpenArgs

[MIEUCHRE]

I finally got it to work by using the default value field.