Search for Record always goes back to the start before finding

E

efandango

I have a combo box that was created using the 'combo box - Find Record'
Wizard which works ok, except that it always refreshes the whole database
going back to the first record, before then finding and going to the selected
record.

The 'combo box - Find Record' Wizard created a macro below:

Action: SearchForRecord
Arguments: , , First, ="[Run_No] = " & Str(Nz(Screen.ActiveControl,0))


Is there a way of having it simply go straight to the record selected,
without going back to the start first?
 

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

VBA for NotInList return to old record or BeforeUpdate value 2
Search combo box 2
Search For Record 0
finding a record based on a combo box choice 19
non-firing Form_Current on new record selected by listbox 2
Question about finding specific record on a Form linked to a table 1
Find Record 5
Combo Box Choose Record Problem 8

Top