AddNew method added two records at time :(

[tiger]

I am working on a form. the text boxes are bound to a data table. so the user
can either view or edit the data table using the form.

Instead of letting user use the navigation button, i created buttons to
perform the view and edit procedure.

when adding a new record, I used AddNew, and Update method of the Recordset.
However, every time a new record was added, it also create a blank record in
the table.

I can get around this problem by adding Eidt method satement right below the
AddNew statement. I couldn't understand why!

 

[Douglas J. Steele]

Bound tables automatically update. If you want to do it yourself, you may
want to go with an unbound form.

 

[doublered]

I am working on a form. the text boxes are bound to a data table. so the user
can either view or edit the data table using the form.

Instead of letting user use the navigation button, i created buttons to
perform the view and edit procedure.

when adding a new record, I used AddNew, and Update method of the Recordset.
However, every time a new record was added, it also create a blank record in
the table.

I can get around this problem by adding Eidt method satement right below the
AddNew statement. I couldn't understand why!