entering data in a form

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

Guest

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.
 
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
 
Back
Top