clear field on error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Me.YourSecondControlName = ""
should clear out the control, using YourSecondControlName of course.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Tab clears field 3
How to clear the previous data 1
Validation Rule Error Messages 1
Auto sum / total 2 fields in a record 4
Access Form - Lock Fields from Editing 0
Requiring data in one field based on another field's contents... 2
Appearing text showing field description 1
Delete contents of form field upon entry 6

Back
Top