Problems with Combo Box

S

suek

My database has 28 "Station Sts". In the combo box, users can do a search on
the location (each has a unique asset number), but if the wrong one comes up,
they cannot move down the list and select the next station st.

My code is:

Private Sub btnSearch_Click()
Me.txtStreetName.SetFocus
DoCmd.FindRecord cboSearch1, , , acSearchAll, , , True


End Sub

Private Sub cboSearch_AfterUpdate()
Me.btnSearch.SetFocus


End Sub

I am not sure if the problem is here, or with the select query, and would
appreciate some help. Thanks
 

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

Dynamic Naming of Form Button 3
Creating a Search using a combo box and then creating a report. 4
Combo Box Choose Record Problem 8
Filtering and Removing Filter based on a combo box 3
Using a combo box to search for a record - error message 7
Combo Box Synchronizing Problem 1
Combo box causes crashes 3
Combo Box & Report Questions 22

Top