Newb question/s

[TomJamieson]

I have a form that I created using autoform from my main table. The form is just for the user to enter a new record. But when opening the form, how do I get the fields to be blank and on a new record by default, rather than starting on the first record with the fields already populated?

And then if I make a button that says "add" but just closes the window, the data should automatically save right?

Thanks.

 

[KenHigg]

You can try setting the forms 'Data Entry' setting to yes and see if that's what you need...

???

 

[Krij]

Private Sub Form_Open(Cancel As Integer)

DoCmd.GoToRecord := acNewRecord
End Sub

I have a form that I created using autoform from my main table. The form is just for the user to enter a new record. But when opening the form, how do I get the fields to be blank and on a new record by default, rather than starting on the first record with the fields already populated?

And then if I make a button that says "add" but just closes the window, the data should automatically save right?

Thanks.