Add Record

[rumples]

How do you clear a form after adding a record? I tried this and it adds the recorde but does not clear the form.
Thanks

Private Sun btnComplete_Click()

DoCmd.GoToRecord , , acNewRecord
DoCmdClose
End Sub

 

[SpandexBobcat]

Hi Rumples,

Draknor39 had this answer to another post (thread705-786100)

Dim ctl As Control
For Each ctl In Me.Controls
        If (ctl.ControlType = acTextBox) Then
            ctl.Value = Null
        End If
Next ctl

Hope this helps...

Simon

"A picture is not worth a 1000 words on the Internet. The information is in the text."