I have a combo box on a form that is based on a query. The combo box lists the 100 counties that are in North Carolina. I also have an option group with 27 controls - one for each letter in the alphabet that when clicked, provides a parameter to the query to only show the counties in the combo box that start with that letter. The extra option (27th control), resets the combo box to all of the counties. I would like a command button that clears the selection in the combo box. I've tried the typical options with the On Click Event, including:
and several others that are out there on the web. The odd thing that I cannot figure out is that the "clear command button" is not clickable until I click the 27th control in the option group that resets the combo box to all of the counties. What's that all about? I would of course like the clear botton to work at any time.
Your thoughts are much appreciated.
Thanks,
David
Code:
Me.Combobox.Value = ""
Me.Combobox.Value = Null
and several others that are out there on the web. The odd thing that I cannot figure out is that the "clear command button" is not clickable until I click the 27th control in the option group that resets the combo box to all of the counties. What's that all about? I would of course like the clear botton to work at any time.
Your thoughts are much appreciated.
Thanks,
David