How to leave linked combobox blank in an option group

[Mansoor Ahmad]

Dear All

I have got an option group with three options. Each option is linked to a combo box. I mean combo boxes have been enabled with each option. So you select an option and then select values from combo box.

My question is that how is it possible that when an option is selected the other combo boxes become empty (No values remain selected even when is not enabled or faded)?

The reason is that I have given references of these combo boxes in a query criteria. If values remain selected in combo boxes, my understanding is that the query takes all those values as parameters and brings incorrect data.

I have struggling with it since this morning. Please help.

 

[Mile-O]

Me.MyCombo = Null

 

[Mansoor Ahmad]

Mile-O-Phile

Thanks. That was very quick.

 

[Mansoor Ahmad]

I have tried and it worked perfectly.

I have used it in BeforeUpdate event of Optiongroup.

It has made my life easy, at least for today.

Thanks