How to get a value from a form with an OnClick event

Richard Comito
Richard Comito used Ask the Experts™
on
I am trying to get a value from a form in Access 2010.  I have a form that has a subform in it.  What I am trying to do is grab the value of the id and then use that value for the subform so that the subform will populate with the correct information according to that ID.  I have not programed in VB for years so I am trying to get myself back on track.

Thanks,

Gabicus
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2006
Commented:
You could just use the form design. When you setup the subform you can define the relationship. Look at the Link Child and Link Master properties of the subform
Richard ComitoDirector of IT

Author

Commented:
Thanks rockiroads,

That did it.
Top Expert 2006

Commented:
No worries :)

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial