RE: [MS_AccessPros] Combo Box Lookup

Which form doesn't work? I tried the frm_Recipe and it seemed to work like I would expect. Duane HookomMS Access MVP
To: MS_Access_Professionals@yahoogroups.com
From: mossj5@comcast.net
Date: Wed, 1 Feb 2012 02:22:28 +0000
Subject: Re: [MS_AccessPros] Combo Box Lookup

I also uploaded the 03 version of the DB to

http://tech.groups.yahoo.com/group/MS_Access_Professionals/files/Recipe/

--- In MS_Access_Professionals@yahoogroups.com, John Moss <mossj5@...> wrote:

>

> here's what I have

>

> a simple recipe DB with 4 tables; tbl_Recipe, tbl_MealType,

> tbl_RecipeType, tbl_Category.

>

> the tbl_MealType, tbl_RecipeType, tbl_Category have a one to many

> relationship to the tbl_Recipe, each meal type can have many recipes, etc..

>

> If I create a form based on a query and only use the tbl_Recipe fields

> that do not include the Foreign Keys to the other tables, then when I

> add the combo box and I use the option "Remember the Value for later

> use" I get the same data for each record in the lookup combo box.

>

> If I use a query that includes the Foreign Keys, I get the same result.

>

> If I create a form and base it on a query and I choose "Store Value in

> Field" and I select the Foreign Key OD field, I get a "Value is not

> Valid" error.

>

> If I create a form and base it on a table and choose "Store Value in

> Field", then it works.

>

> It's obvious I doing something stupid, but can't figure it out.

>

> Thanks,

> John M.

>

> On 1/31/2012 1:25 PM, John Viescas wrote:

> >

> > John-

> >

> > You should normally use a query as the Row Source of a combo box, but

> > a table

> > can work, too. Are you saying it only works using a table and does not

> > using a

> > query?

> >

> > 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/

> > (Lahaina, HI)

> >

> > -----Original Message-----

> > From: MS_Access_Professionals@yahoogroups.com

> > <mailto:MS_Access_Professionals%40yahoogroups.com>

> > [mailto:MS_Access_Professionals@yahoogroups.com

> > <mailto:MS_Access_Professionals%40yahoogroups.com>] On Behalf Of yshopper

> > Sent: Tuesday, January 31, 2012 10:16 AM

> > To: MS_Access_Professionals@yahoogroups.com

> > <mailto:MS_Access_Professionals%40yahoogroups.com>

> > Subject: [MS_AccessPros] Combo Box Lookup

> >

> > I added a combo box to a form to use as a lookup. Why does this work

> > using a

> > Table instead of a Query?

> >

> > Thanks for any insight.

> >

> > John

> >

> > ------------------------------------

> >

> > Yahoo! Groups Links

> >

> >

>

>

>

> [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/