RE: [MS_AccessPros] Combo Box Lookup

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@comcast.net
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]

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

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/