>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.
I agree with Nick. I would change the functionality of the Add button. First I would prompt for a Job number [unbound textbox]. Then use SPT. Then append blank if valid. You could even create a parameterized view based on ?nJobNo [or ?cJobNo] then do a requery() of the view. If it returns a record, append blank at that point.
Mark McCasland
Midlothian, TX USA