Find Key Value for Just Added record

[GreenFella]

I have an Access application that accesses a SQL Server backend. The application is adding a record to the Customer table. Customer table has a Primary Key of CustID which is also an Identity (auto number) field.

When a new record is added to the table Customer I need to be able to identify the value generated as the CustID so that I can add a record to the CustomerAddress table using the CustID value from the new record as a foreign key.

Does anyone know of a way to capture the newly generated CustID value?

TIA
Stephen

 

[PHV]

Have a look at @@Identity

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886