MS Access getting the FieldID from a newly inserted record

I am using access 2000 for an intranet site, and would like to know how to get the recordid of a newly created record. here is the code. INSERT INTO TableName (FieldName) VALUES('#Form.FieldValue#') I want to be able to display the newly created record, but need the key value

Re: MS Access getting the FieldID from a newly inserted record

The usual solution is to wrap two queries into a cftransaction Question of my own: I've never really found out what the difference is in the various isolation levels. Can someone explain them, or point me in the right direction? Options: TIA. -- Billy Cravens [EMAIL PROTECTED] E

Re: MS Access getting the FieldID from a newly inserted record

- Original Message - From: "Eric Dawson" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, September 12, 2000 12:20 PM Subject: MS Access getting the FieldID from a newly inserted record I am using access 2000 for an intranet site, and would like t