Button to reload form how it was first loaded

[Simon]

I have a form that i use to scan Parcel Despatch Numbers in to say the
parcel is despatched

On the form i have parcel Number what i use to scan parcel number then
up comes the customers Details

I would like a buttom that will reset the form back to how it was when
it was loaded, All the set focus and default values set

How do i do this ? ( instead of closing the form and reopening it)

 

[Wayne-I-M]

Hi

Looking at your question I think (may be wrong) that when you open your form
you go to a new record.
In this case just add a button to go to a another new record

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


The other thing that may be happening is that you using an unbound form.
In this case you could referesh to the form's data

Private Sub InsertButtonNameHere_Click()
DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70
End Sub


If these are not correct you could providfe more information about what
happens when you 1st open the form. Is it bound to a table/query, etc