I need to create a record and display it on the same page.<BR>What would be the best way to make sure that it does not get messed up?
Are you using Access? If so...Use this.<BR><BR>http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=79
The Jet 4 SQL extensions also allow the use of the SQL syntax:<BR>SELECT @@identity<BR><BR>So try:<BR><BR>set rst = Connection.Execute("insert statement" & " Select @@identity").NextRecordset
It's pretty amazing how many things are in the JET version 4 drivers that are not in Access! <BR><BR>I would have thought that the same group that worked on Access at MS also worked on the Jet drivers, but it obviously isn't so.<BR>
Once you do, you'll still be answering the same questions!!!
My wife, two rooms away and up a flight of stairs, asked me what was so funny.<BR><BR>I don't think she got the joke. But I sure did.<BR><BR>Thanks, I needed that!<BR><BR>Bill<BR><BR>