Form Validation Rule

[galkej]

Hello,



I have a form in which there are fields that have validation rules for the quantity and types of characters that are entered by the people on the production floor. The operators are wanting me to refine this so that if they accidentally enter or scan the wrong information, the affected field will automatically be cleared of the previously-entered contents (after they clear the validation error pop-up window). How can I accomplish this?

Thanks

[Missinglinq]

Where/how are these Validations being done; using the Validation Properties at the Table or Form level or through VBA code in the Form?

Linq ;0)>

[galkej]

Just in the Validation Properties, i.e. Like "????????????" to ensure that they scan the barcode with the 12 characters, and not the adjacent one that has 10 characters.

I need all other fields on the form to remain static after the error event; I only want the info incorrectly entered in the offending field (I'll call this field "Serial Number") to automatically be deleted after acknowledging the validation pop-up window. Someone recommended the code below, but this clears out ALL of the fields on my form. I only want the serial number field to auto-clear itself after the validation error.

Private Sub Command17_Click()
If Me.Dirty Then
Me.Undo
End If
End Sub

[Missinglinq]

See what this does:

Private Sub Command17_Click()

If Me.Dirty Then
   Me.[Serial Number].Undo
End If

End Sub

Linq ;0)>

[galkej]

Thanks for the reply. I tried your recommendation, but unfortunately nothing happens after I clear the validation pop-up window with the modified code.