>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
It is impossible to make programs idiot proof. Idiots are too cleaver.
MCP( Tcp/Ip )