Add new record with VB

[Kevin]

I have a form which displays a record at a time to allow
user to edit the record. I have hidden the nagivation
button. However, I would like users to be able to add new
records by clicking a button. What do I need to put into
the button's click event? I don't know how to reference to
the form's recordset and use the AddNew method.

Many thanks

Kevin

 

[Van T. Dinh]

I read that you want to make a new Record the CurrentRecord on the Form so
that the user can enter data for the new Record. In this case, you only
need the statement:

DoCmd.GoToRecord , , acNewRec

in the CommandButton_Click Event Procedure.