Pass name of control to a form

[Emma Aumack]

How do I pass the name of a control on Form_A to Form_B? For example: I
have a hidden control in Form_A named ControlA1_ID, I want to pass the name
of that control to Form_B. Then when Form_B closes, I want to place a value,
say from Form_B.ControlB_ID, into Form_A.ControlA1_ID.

How do I reference the control name? Forms!Form_A.ControlA1_ID.Name?

So that I can assign it to a variable for use with OpenArgs.

 

[Jeff Boyce]

Emma

You may not need to "pass" anything.

Take a look at Access HELP for "expressions". You can refer to a control on
a form with something like:

Forms!YourOtherForm!YourControlName

This lets one form "look" at a value in a control on another form.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/