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.
 

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

format number generated by VB code 1
Access Click in Table to Open Form 0
Insert record based on fields on form 3
How Do I ? 6
Data Entry Form and Auto Number ID 2
Access Automatically Send a notification email once a record is added 0
Create New Entry From Exisiting Data 8
Record entry on an unbound form 1

Back
Top