Get record # for record just witten or being written?

[CraigBest]

Hi - I am writing a record to a table on an Access 2003 DB using JET. The table has an autonumber Record ID that gets attached to each record as it gets written. I'd like to know if there is a way to get back the record number for the record I am writing or just wrote during an insert query?

Thanks

Craig

CraigHartz

 

[shavon]

@identity should work. Just Google it to see how it's used.

 

[CraigBest]

Okay thanks - Haven't had a chance to try it yet but it sounds promising.

CraigHartz