Combo Box Clearance

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I create a command button to clear the contents of one or more combo
boxes on my form? Any help appreciated
 
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.
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to adjacent field from a record 6
Add the command "Clear All Filters" to a Command Button in Access 2010? 0
Access Microsoft access database(creating a search engine form) 0
combo box filter 1
Search records by unbound combo box - please help! 5
Annotating and expired date 3
Auto-populate fields with combo box AND date range 9
how to show data only from selected combo boxes ? 0

Back
Top