TextBox Record Inquiry

A

AFSSkier

Using an unbound text box to enter a single SKU number on a form. What is
the safest & quickest way to inquire (search for) a single record from a
table? The table almost a ¼ million records. The safest where no records
are edited, or deleted. This can be a single form or use a sub-form. SKU
field is numeric. I would also like create a similar form to inquire against
a text customer ID field.

I have found that there are several options available, Filter By Form,
FindFirst, LostFocus, SetFocus, DLookup, ComboBox. What is the best record
inquiry?
 

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

DMax on existing record to increment serialized # fails 1
Find Record in exel worksheet from UserForm 1
Capturing start and end time of a form 6
First Subform record gets modified when closing form 3
Save record sequence number from form 2
Using DSUM to get running total on a filtered form 0
Set focus in a specific record within a subform 1
Combo Box Problem 5

Top