How do I use my key?

[Kate]

I have some SQL where I Insert into a table with a primary
key field that is an Autonumber. Once I have done that can
I then use this field without having to go and read the
record?

I.e. Table1 with field1 as autonumber, field2, field3

Insert into Table1 (field2, field3)
Values ('X', 'Y')

Update Table2 SET [Sequence] = table1.field1
Where etc

I'm using ACCESS 2002 (and 2003)

If not then how do I retrieve the record so I can use the
keys value?

Thank you

 

[Van T. Dinh]

I assume you are doing this in code. If you are using DAO code, check
Access VB Help on the LastModified Property.