data entry and look up form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form based on a table that will be used for order entry. The ID
field is a number that is generated using a VB code. I would like to amend
the form so that if the user types in the number of an existing record the
form will automatically go to that record. Is there a macro or VB code that
will achieve this? The table name is Quote, the field name is QuoteNum.

Any help is very much appreciated.
 
Back
Top