Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Aug 2013
    Posts
    6
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Clear Combobox Selection

    Hi,

    New to the forum and new to access.
    I have 2 comboboxes. With the first combo I select a Provider.(unbound)
    With this selection it in return will populate the 2nd combobox( unbound) for me to choose a product.
    I make a choice it it is displayed it the box.
    What I want to do is if I make a new selection in combobox 1 I want the choice I made it the 2nd combo to clear.( which is still visible)
    This will allow me to make a different selection from the combo.

    Any help would be appreciated.

  2. #2
    Star Lounger
    Join Date
    Dec 2009
    Location
    Findlay, Ohio
    Posts
    57
    Thanks
    4
    Thanked 6 Times in 6 Posts
    How about: Combo2.Value = ""

  3. The Following User Says Thank You to orangehat For This Useful Post:

    Charlescd (2013-09-02)

  4. #3
    New Lounger
    Join Date
    Aug 2013
    Posts
    6
    Thanks
    3
    Thanked 0 Times in 0 Posts
    orangehat,

    Thanks for the reply. However, I did try as you suggested.
    I also set the "Focus" to combo2 and set to "Null".

    Charles

  5. #4
    New Lounger
    Join Date
    Aug 2013
    Posts
    6
    Thanks
    3
    Thanked 0 Times in 0 Posts
    Hi,

    Solved my problem. I had the "Control Source" set. Removed it and all worked for me.
    Thanks for those who looek at and helped.

    Charles

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •