The Form_Load event is never the place for this kind of code because placing it there means that it will only apply to the Record that is initially displayed when the Form opens. The syntax you need would be something like this:
Code:
Private Sub Form_Current()
Dim ctl As Control
Dim i As Integer
If Me.NewRecord Then
For Each ctl In Forms!DynamicDataForm.Controls
If ctl.ControlType = acTextBox Then
If InStr(ctl.Name, "Control") > 0 And ctl.Value <> "Not Used" Then
ctl.Value = ""
End If
End If
Next
End If
End Sub
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007