Clearing information form Combo box

[dcjones]

Hi All,

I have read all the post regarding Combo Box and have not found the anwser to my problem.

Simply, I have a number of Combo Boxs on a Form. After the user has selected the items from the Combo Boxs the record they have requested appears.

How do I produce a Command Button to CLEAR the Combo boxs.


Kind Regards


Dereck

 

[RichO]

In the event code for the command button, try:

Me.MyComboBox.RowSource = ""

Another option would be to simply disable the combo box instead:

Me.MyComboBox.Enabled = False