Can I get some input on how best to do this?? <BR><BR>I need to update a specific record and add a new record at the same time. <BR><BR>Can I do this? <BR><BR>Thanks for the help.
I did an addnew but commented out the addnew for what I needed to update. <BR><BR>Apparently, when you .addnew it adds a new record and if you remove it, it will update the record. <BR><BR>;}
isql="insert..."<BR>usql="update..."<BR>conn.execu te(isql)<BR>conn.execute(usql)<BR><BR>this will do it!! hope this solves your problem!