>I have a button that Appends a Blank record to a table. The user types in a job number. This job no. is then validated to a cursor created by sql-pass-through. If there is no match what is the best way to undo the append blank. This is a multi-user app.

The best way would be first get the job number in a textbox, validate it and if it is good, only then append the blank record.