Command Button problem

[Haynesey]

I have a main data form that can be accessed to view all records. However, should the user wish to enter a new record, I want to be able to include a button on the front screen that will open the data form, but with no existing data showing.

Is this possible?

Thanks in advance
Lee

 

[Graham T]

Lee

Use the following:

Private Sub [YourCommandButtonName]_Click()
DoCmd.OpenForm "[YourFormName]", acNormal, , , acFormAdd
End Sub

HTH

Graham