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]
> >
>
Tidak ada komentar:
Posting Komentar