Combo Box Clearance

R

Ron

How do I create a command button to clear the contents of one or more combo
boxes on my form? Any help appreciated
 
W

Wayne Morgan

Assuming the combo boxes are unbound or, if bound, that there are no
restrictions on Null values, the code would be

Me.Combo1 = Null
Me.Combo2 = Null
Me.Combo3 = Null
'etc

Adjust the names above to match the names of your combo boxes.
 
R

Ron

Thank, that worked great

Wayne Morgan said:
Assuming the combo boxes are unbound or, if bound, that there are no
restrictions on Null values, the code would be

Me.Combo1 = Null
Me.Combo2 = Null
Me.Combo3 = Null
'etc

Adjust the names above to match the names of your combo boxes.
Click to expand...
 
Top