clear field on error

J

JR Hester

USing Access 2000 on Windows XP OS

My form has only two fields, the first displays an entry from a table; the
second accepts input from user. Purpose is to duplicate the entry in first
field.

Successfully set a validation rule requiring entry to = the displayed data,
prompting user to try again. Would like to clear the field contents as user
presses the OK button on the error notification dialog box, forcing user to
completely re-enter the field contents!

Any suggestions?

Thanks
 
R

ruralguy via AccessMonster.com

Me.YourSecondControlName = ""
should clear out the control, using YourSecondControlName of course.
 
Top