SetFocus??

[ladydazy]

Well well well. I cannot believe I forgot how to do this...

I have 2 forms. EmployeeId on the tblEmployee
and EmployeeId on tblSection.

I want when I enter data in frmEmployee, when I click NEXT (to go to frmSection), that EmployeeId be there in frmSection.EmployeeId automatically.
What is the code to do this please?

Is it a setfocus action?? I just cannot remember.

 

[fpendino]

After you open the form, you can just relay that data over as follows.

Forms!frmSection!EmployeeID = me.EmployeeID

Put that directly after you docmd.openform code.