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