Results 1 to 4 of 4

Thread: Combobox

  1. #1
    Join Date
    Apr 2009
    Posts
    85

    Unanswered: Combobox

    Hello

    Im working in Access 2003 and I have a form with one Unbound combobox and a subform. The combobox is populated by a qry. The entries in the combobox are storage locations for equipment in our warehouse, once a week I compare whats on the self to whats in the database and make appropriate changes, the form works fine. What I would like is a command button attached to the combobox so I only have to click this command button to go to the next entrie in the combobox, can anyone help me with this, I did try googling this, no luck. Thanks

  2. #2
    Join Date
    Sep 2006
    Location
    Surrey, UK
    Posts
    994
    Provided Answers: 2
    I think that you need to change the combo box into a list box. Then you can loop through the items in the list until you get to the selected one, deselect it and select the next one. Then a requery of the form will reveal the next item's records.

  3. #3
    Join Date
    Apr 2009
    Posts
    85
    Thank you weejas, that worked

  4. #4
    Join Date
    Sep 2006
    Location
    Surrey, UK
    Posts
    994
    Provided Answers: 2
    You're welcome!

Posting Permissions

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