entering data in a form

A

abest

I created a form to enter data in the database to be used by other workers.
Here is my problem. When I enter the information it goes into the file but
my form still has the information on it. Can you please tell me how to
remove the info. from my form but not the database when I click on my save
button.
 
D

Dummyhk

Function BlankFormControls(f As Form)
'
' Copies Null to all fields on a form - ignores errors
'
Dim i As Integer, C As Control
On Error Resume Next
For i = 0 To f.Count - 1
f(i) = Null
Next i
End Function

Private Sub xxxxx
:
:
Call BlankFormControls(Me)
:
:
End Sub
 
Top