Auto Fill Form Field with Value from Previous Form

[Mearntain]

Ok, I've searched around a bit, and can't find a solution that will work for me. Hopefully this is an easy topic:

I've got one form that a user will start on, titled "Query Form" - Only one text box is here and it is titled "text0"

Upon hitting enter here, a new form is opened up titled "Time_IN_Form".



What I would like to do is have the value from text0 on the Query Form to automatically populate Emp_ID on Time_IN_Form so the user doesn't have to enter their employee number twice (only once via the first form).

What is the best way to do this? I have tried playing with global variables but didnt have any luck with that. Thanks in advance!

[pbaldy]

DoCmd.OpenForm...
Forms!FormName.TextboxName = Me.Text0

[Mearntain]

What is the proper way to type this?

If I try - Forms!Query Form.text0 = Me.Emp_ID : It gives an error for Compile Error, expected =

If I try - Forms!"Query Form".text0 = Me.Emp_ID : It gives an error for Compile Error, expected end of statement

What am I typing in wrong? I tried this method earlier before posting and couldn't get it to work then either. Thanks

[pbaldy]

Because of the inadvisable space you need brackets:

Forms![Query Form].text0 = Me.Emp_ID

[Mearntain]

Thanks alot! Got it working now

[pbaldy]

Happy to help!