John-
Use a Combo Box or List Box and set the Row Source to fetch the values from the
related table. Set the Control Source to the field that's the Foreign Key in
the table being edited by the form.
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of yshopper
Sent: Wednesday, November 30, 2011 6:05 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Form Control for Lookup field
I am trying to bind a form control to a lookup table. I read that doing this at
the Form level is best practice instead of at the Table level.
How do I bind the form control to a field in a different table than the one the
form is based on?
Thanks,
John
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar