I have a form which inserts data into an access database. Once that data is inserted I need to access the ID for that data so that I can send a URL in an email for them to click on so that the information can be updated by somebody else. I am running into the problem once I insert it tells me it does not understand #id#. I do a query right after the insertion so that it can pull that info, but how do I cross reference?
Steven Lancaster WebMaster Core Laboratories 6316 Windfern Houston, TX 77040 713-328-2532 (Office) 713-328-2150 (Fax) 832-259-3010 (Cell) mailto:[EMAIL PROTECTED] http://www.corelab.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

