RE: [MS_AccessPros] Combo Box Lookup

I'm not sure why you need to base the form record source on both tables. The combo box "creates" a reference to the other table.

Duane Hookom
MS Access MVP

To: MS_Access_Professionals@yahoogroups.com
From: jlinux@comcast.net
Date: Thu, 1 Dec 2011 21:56:29 +0000
Subject: Re: [MS_AccessPros] Combo Box Lookup

Sorry, more info. The Control source for the Combo box is the Foreign Key to the lookup table.

The Form record source in the Query based on those 2 tables.

The Control Row source is a Select Query.

--- In MS_Access_Professionals@yahoogroups.com, "yshopper" <jlinux@...> wrote:
>
> The Control Source is the Foreign Key from the other table. The Row source is the Query.
>
> I don't see how to set the record source for the form.
>
> Sorry for the duplicate post.
>
> --- In MS_Access_Professionals@yahoogroups.com, Duane Hookom <duanehookom@> wrote:
> >
> >
> > John,
> >
> > Apparently the combo box is not bound to a field in the form's record source. "Control Source" can't be a query or table but a "Row Source" can. The "Control Source" should be the name of the bound field.
> >
> > Duane Hookom
> > MS Access MVP
> >
> >
> >
> >
> > To: MS_Access_Professionals@yahoogroups.com
> > From: jlinux@
> > Date: Thu, 1 Dec 2011 21:04:03 +0000
> > Subject: [MS_AccessPros] Combo Box Lookup
> >
> >
> >
> >
> >
> >
> > I have a Combo box on a Form that is used as a Lookup field. The Cotrol source is a Query based on a separate table.
> >
> > When I go to a record and change one of the Combo selections, all the records are change to match.
> >
> > I need to have each selection unique to that record.
> >
> > What did I do wrong or what property did I forget to set?
> >
> > Thanks,
> > John
> >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>

[Non-text portions of this message have been removed]

------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/