Lookup on Text Box

[vdc1]

My text box is where you scan SKU numbers on various product. Once the scanner has entered the SKU number it tabs to the next focus. The next focus is a cmdbutton which begins the lookup.
If the code finds that the SKU has already been entered into the system then the next process should be to Enter quantities of that product.
IF NOT then it should begin to enter new SKU details into the main table.

How do I use code to do the lookup instead of a query? Or should I be using a combo box to enter the SKU and use the 'limit to list' feature. I currently have a query that returns the search results, however that takes much longer then I would like to allow.

 

[RuralGuy]

If the field is indexed then a FindFirst should run pretty quickly. This assumes you will be looking in the table that is bound to the form. Use the RecordSetClone in DAO.

 

[vdc1]

No the form is not bound to the table where the lookup will happen. The form is just an entry form to manifest. The test box is then supposed to lookup on another table to see if the entery has been made already or not.

 

[RuralGuy]

OK, then if the field is indexed a DLookup() should run quickly as well.