DoCmd.Execute to insert a record

  • Thread starter Thread starter Bill Stanton
  • Start date Start date
B

Bill Stanton

After a DoCmd.Execute to insert a record
into a table, is there an easy way to find out
the value that was created for the autonumber
field in the table?
Thanks,
Bill
 
try creating a field, link it to the ID field (if that's the field for
the auto number)and then when the new record is produced, the
autonumber will be shown in the new field on the form
 
Nothing like a little bit of experience, eh Andy?
Thanks,
Bill
 
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

VBA to run query record 6
Get PK or autonumber of Newly appended Record 6
VBA - retrieve data on last create named range from previous inserted named range 0
Rolling back transactions 2
Finding RecordID after Insert Into 2
dbSeeChanges 3
How to Populate Data from a table to another 0
Creating Checkbox Fields For Every Record 0

Back
Top