Results 1 to 3 of 3
  1. #1
    CharissaBelle is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2016
    Posts
    81

    Clear the Combobox using a button

    Hello. I have three comboboxes that are used on a form to filter the form. They interact with one another also. I want to be able to "reset" the comboboxes by using a button. Basically, I want it to clear out so it is ready for someone to start typing. Does this make sense? And does anyone have any advice?



    Thanks in advance!

  2. #2
    Perceptus's Avatar
    Perceptus is offline Expert
    Windows 7 64bit Access 2007
    Join Date
    Nov 2012
    Location
    Knoxville, Tennessee
    Posts
    659
    You want the ComboBox to be cleared out but keep the dropdown items?

    If the combobox was named cmbJuices
    Sub Button1_Click()
    cmbJuices = ""
    end sub

  3. #3
    CharissaBelle is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2016
    Posts
    81
    Solved it. I set each combobox.Value = Null

Please reply to this thread with any new information or opinions.

Similar Threads

  1. code for clear button is not working
    By tommyried in forum Programming
    Replies: 3
    Last Post: 03-13-2014, 02:50 AM
  2. Button to clear a record, not working
    By snipe in forum Forms
    Replies: 3
    Last Post: 02-17-2014, 02:23 PM
  3. clear fields button not working
    By fainterm in forum Forms
    Replies: 20
    Last Post: 02-04-2014, 01:13 PM
  4. How to create a clear button
    By tomneedshelp in forum Access
    Replies: 1
    Last Post: 05-10-2012, 05:21 AM
  5. Search and Clear button
    By polk383 in forum Programming
    Replies: 1
    Last Post: 08-30-2006, 08:51 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums