Blank form on open

[benc]

I would like to set the form to open on a blank form as though to enter a new record but for the user to use the scroll buttons to search past records. I have tried setting the Data Entry property to yes but i cannot scroll through past records. Can any one help? Thanks

 

[Poot]

DoCmd

Hiya... you want to add in on your form when opening:

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

This will open your form at a new blank record... your user will then be able to scroll through your records if desired.

HTH

Poot.