>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.

When they click the Add button you could call a small form with a txtVariable box to get the proposed job no. You could then check for a duplicate and if found not execute the append. That way Nick's requirement is satisfied and so is yours.

Terry