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.