Searching for part with four criterias

[kabir_hussein]

Hi i have a form where i can search for parts in the database. However the form ( please check the attachement) is done using radio buttons which u click on to enable different searching methods.

Is there any way when you click on another radio button the previous drop down box can be set to clear it self.

all help is appreciated

I have all the drop down button lined to one query but if one doesnt match it causes problems

 

[Mile-O]

Put Me.MyCombo = Null in the frame's AfterUpdate event.

 

[kabir_hussein]

many many thanks i just worked it out earlier but thank you for helping me.