RE: [MS_AccessPros] Re: Cascading Combo Box

Bill,
Do yourself a favor and rename your combo box to something that makes sense. Then you have about 45 minutes to make your New Years resolution to find and consistently apply a good naming convention!

Duane hookom
MS Access MVP

To: MS_Access_Professionals@yahoogroups.com
From: Bill.Singer@at-group.net
Date: Sun, 1 Jan 2012 04:06:12 +0000
Subject: [MS_AccessPros] Re: Cascading Combo Box

Duane,

Yes, Snow finally..

The second combo box is based on a query. The query is sorted with this criteria.

[Forms]![f_Jobs]![Combo74]

Where [Combo74] is the first combo box. Combo74 picks a name that is associated with a ID number. The second Combo box sorts the records for those records with that ID number.

Will the On Current event of the form update the 2nd combo box each time I move to a new record? I will give it a try.

Thank you,

Bill

--- In MS_Access_Professionals@yahoogroups.com, "Duane" <duanehookom@...> wrote:

>

> Bill,

> Can you share how you are filtering the second combo box? Is there something in its criteria or are you changing the SQL of the Row Source or some other method.

>

> Whatever you are doing, you probably need to do it in the On Current event of the form.

>

> Duane Hookom

> MS Access MVP (hey it's finally snowing in MN)

>

> --- In MS_Access_Professionals@yahoogroups.com, "agent1of6" <Bill.Singer@> wrote:

> >

> > Here is the good news. Thanks to this site I have succesfully set up two combo boxes with the options in the second combo box based on the selection in the first combo box.

> >

> > I have the "got focus" property on the second combo box set to refresh the record. Both the first combo box and the second combo box are entering the correct ID number into the correct table. The second combo box work off of a query that sorts based on the selection in the first combo box.

> >

> > There are about 300 records in the table.

> >

> > The problem is that we I open the form and go to the next record or the previous record the second combo box does not show the selection that was made. It just shows as blank. When I click on the box the correct item shows up. It is as if it was there all the time but waiting me to touch it with the mouse. This is frustrating. I would like the second combo box to show the selected item as I go through the next record.

> >

> > I would think the combo box would refresh when I go to the next record but it will not show the selection until I click on it.

> >

> > What did I do wrong?

> >

> > Bill

> > Minnesota

> > Happy New Year!!

> >

>

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