Need help w/ Clearing Form

[David Ehrenreich]

Hello,

I would like to add a procedure on the On Change
expressions that would clear the form of any text
entered. It can not be a new record.

Any help would be great

Thank you
David Ehrenreich

 

[Eric D.]

Hey,

Try this:
========================
Dim ctrl As Control

For Each ctrl On Me.Controls
If ctrl.ControlType = acTextBox Then
ctrl.Value = ""
End If
Next ctrl
=======================
Hope this helps.