Reload the form with no data

[Simon]

When i open up a form it has no data in it, i then use my form that
will look up data ect but i would then like a button that clear all
data so its like how it was first loaded up


Thanks

 

[Wayne-I-M]

A form will show all data that is held in the bound table field (bound to the
control in the form).

To open you form blank - you need to go to a new record

Private Sub Form_Open(Cancel As Integer)
DoCmd.GoToRecord , , acNewRec
End Sub

Or use the data entry = yes

Or with a button

Private Sub ButtonName_Click()
DoCmd.GoToRecord , , acNewRec
End Sub

But make sure you don't just keep creating lots of empty records ???