Getting ID from new record being added?

T

twen

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.
 
M

Mark A. Sam

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
 
Top