Hi,
I've a query which inserts several form fields and values to a DB - I've set
the ID of the records in Access to AutoNumber, and immediately after
inserting the data I want to find out what the ID is.
So usually, I query the DB using the form fields in the WHERE statements
(i.e. WHERE email = '#form.email#' subject = '#form.subject#').
The quibble I have is a) this isn't working, and I'm not getting the ID, and
b) it seems an archaic way to do it.
Does anyone have any thoughts on the best way of obtaining the ID of a
Autonumber field?
Thanks
Will
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
