Insert Into 1

[andzejek]

I'm adding record to the table which has automatically numbered field: cust_id. How can I find whot number is in this field of just inserted record. Code

SQLstr = "Insert into customer ([f_name],[l_name]) Values('" & str_F_Name & "','" & str_L_Name & "');"

CurrentDb.Execute SQLstr

cust_id=?

Andrew

 

[genomon]

Can you use DLookup for the number with the names as parameters?

Silence is golden.
Duct tape is silver.

 

[andzejek]

Names can duplicate. Only unique field in this table is cust_id.

 

[TheAceMan1]

. . . and how about:

[blue]   Dim ID
   
   ID = DMax("[cust_id]", "TableName")[/blue]

See Ya! . . . . . .

Be sure to see FAQ219-2884:

 

[andzejek]

Thank you! this is whot I was looking for!