Linking fields

[TheRiver]

I have a main form with a command button which opens up another a sub form. The Employee ID links all the forms together, but how do I get it that when I input into the subform that the employee ID is automatically filled in?

 

[gavinjb]

The Easiest way I can think off is to use the OpenArgs to Pass the ID to the Subform and in the open Event on the subform have some code simular to the following

If Not IsNull(me.openargs) then
EmpID=me.OpenArgs
End If

This should work.

 

[MarkWright]

Hello,
if I unsderstand you right, you are trying to give the employee ID as a standard to other forms that you are opening with a cmdbutton. You can use ->
employee_ID = Forms("formname&quot![employee ID]

Hope this is what you were looking for

Mark

 

[TheRiver]

I dont really understand either of these.

 

[Rolliee]

Use your own new record button and add the field right after the


docmd.gotorecord,,acNew

me.field = forms![MyParentForm]![MyField]


rollie@besys.net