I have a trigger that rolls back the user's entry if it meets the criteria
in the trigger.

BEGIN
RAISERROR('The Company,Customer,FileID you entered is already in
use, please change your entry.', 16,1)
ROLLBACK TRAN
END


Is there any way to get this trigger to refresh the entry without the user
having to hit the 'esc' key from the client interface? (the client interface
being used is Access 2000)