I fixed them before I uploaded. I just uploaded a new 03 version DB.
frm_Recipe2 stores the same date in the menu type combo box. frm_Recipe3 says the Value isn't valid.
frm_recipe4 has the same error.
frm_Recipe5 only shows 2 records.
--- In MS_Access_Professionals@yahoogroups.com, Duane Hookom <duanehookom@...> wrote:
>
>
> 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@...
> 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]
>
Tidak ada komentar:
Posting Komentar