Getting ID from new record being added?

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

Guest

I am adding a record to a contact table, and I have an address ID from a
previous form. I was wondering if when you add a new record to a table via a
form, is there any way to retrieve the newly added record's id so I can add a
new record to a lookup table? if that is confusing please respond and I will
try and clear it up a little bit.
 
Put a textbox on the form with the address id as the controlsource. As soon
as the record is created the ID will be assigned if the table is an Access
table. If it is an SQL Server table it will be create when you move to a
new record.

God Bless,

Mark A. Sam
 

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

DoCmd.RUNSQL INSERT Queries 4
Need combo box to refresh when moving to new record 2017 1
VBA - retrieve data on last create named range from previous inserted named range 0
Access Automatically Send a notification email once a record is added 0
How to set different combo box values for new record? 6
adding new records 5
When added a record wil automatically can be chosed in other form 2
Add record, return user to that record. 5

Back
Top