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