instant update combo list based on option group

[deetron]

I have a mutually exclusive group of dates (month, year, quater) which I select with an option (radio button). Right below is a combo box (i.e. jan/feb/mar, etc. for month option; 2003/2004/2005, etc. for year option...etc) which gives a list of dates based on selected option. I need this box to update instantaneously when I select a new option. I use Row Source Type = Table/Query control to build an expression for selection of combo list. The Row Source field is as follows:

SELECT DISTINCT Switch([grpDates]=1,[Month],[grpDates]=2,[Qtr],[grpDates]=3,[Year]) AS Dates FROM qryDates;

The problem I'm seeing is it appropriately choses the combo list based on selected option only 1st time. It doesn't update when I re-select I new option. I am forced to close the form and re-open it again.

How do we tell Row Source to update instantly (I though Switch function is an instant function - I also tried using IIF(), which produced same result).

What am I doing wrong???

 

[SydneyGeek]

This is a standard issue with combo and list boxes, as well as subforms. First time you select or acitivate, fine. Next time you need to requery the combo.

To get to the module behind the form, do this:
Right-click the option group, select Properties, click the Events tab, and double-click the blank line next to After Update. You'll see [Event Procedure].
Click the Builder (...) button and paste this code in the blank line:
[MyComboName].Requery (change to suit the name of your control)

You'll need to do this for each Option Group.

Denis

 

[deetron]

That's IT! thank you, Denis