Thanks John. That set me straight. I forgot to relate the tables :(
--- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@...> wrote:
>
> 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