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!