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
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.