Add entry to a table with a form

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

Guest

Access 2000. What is the syntax of VBA to add entry to a form with a
'autonumber' field?
Thanks in advance!
 
Usually, Autonumber fields will take care of themselves. Just do whatever you
need to do for the other fields and the Autonumber will be put in by Access.

For example, simply moving to the next record, once data entry has been
commenced in any other field for the record (excluding any blank Required
fields) will cause Access to complete the 'Auto' field.

AM
 
Thanks .

AM_2004 said:
Usually, Autonumber fields will take care of themselves. Just do whatever you
need to do for the other fields and the Autonumber will be put in by Access.

For example, simply moving to the next record, once data entry has been
commenced in any other field for the record (excluding any blank Required
fields) will cause Access to complete the 'Auto' field.

AM
Click to expand...
 
You must log in or register to reply here.

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

2 tables, 1 query, 1 form, 1 subform 6
Access Automatically Send a notification email once a record is added 0
Access Daily Entry with multiple entries per field 0
Data entry to table from a form 1
Populate field from data in another table 7
Avoiding Duplicate Entries 4
table-query-entry form 1
Excel VBA - Problem with Closing Print Preview 0

Back
Top