initializing forms

[sherik]

Hi everyone. I am a novice in Access. So, could you please with the following problem. I have created a form which includes customer information and added a button which adds new customer. The problem is when I open the form, the form is already filled with one of the existing customer information, and when press button add button, the entries are cleared and then I am able to enter new customer info. What I want is when I open the form, it is cleared so that the entries are empty (empty name surname and so on), so I could directly enter new customer info. Thanks a lot.

[June7]

Can set the form DataEntry property to Yes and then the form will open only to new record. Existing records will not be available for viewing.

[Bob Fitz]

Alternatively, you could put the following line in the form's On Open event. The existing records would then be available.
DoCmd.GoToRecord , ,acNewRec

[sherik]

Into VBA or where?

Alternatively, you could put the following line in the form's On Open event. The existing records would then be available.
DoCmd.GoToRecord , ,acNewRec

[Bob Fitz]

It would need to be in the forms code module and would look like:

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

The forms On Open event property should be set to [Event Procedure]