Clearing Combo Box Results using VBA

[chippyles]

I have 6 combo boxes at the top of the form and people can come in and click from a list what they want to see. They click 'go' and the results are displayed at the bottom of the page.

I would like to create a button that clears the combo results. What would be the VBA for clearing the 6 combo boxes if their names are 'SID','H','VEN','EW1','OP', & 'LOT1'?

thanks!!

 

[PHV]

Me!SID = Null
Me!H = Null
...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244