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