Newbie question: Form overwrites record

  • Thread starter Thread starter Kevin C Niven
  • Start date Start date
K

Kevin C Niven

I have been following along in the Access 2007 Inside/Out book. I have
come to the part about forms, and have followed the directions in
creating a form.

I am just playing with a simple database of names with one table with
First, Middle and Last names. So I created a form with First, Middle
and Last fields.

In design View, I add a button. I get the command button wizard. I
select Record Operations: Add New Record.

When I test the form, I fill out the names fields and click my Add
Record button.

What the...? It replaces the first record in the table.

I would like it to ADD a new record, not replace one. I thought that
was the obvious purpose of the "Add New Record" operation. What am I
doing wrong?

Can someone explain to me how to create a button that adds a new
record? I am deeply confused about this. It seems to me to be the
most obvious type of form you would want to create and yet...fail.

Thanks,
Kevin
 
Kevin

I suspect the confusion hinges on your definition of "the first record of
the table".

Are you saying that you already have a record showing in the form, and that
clicking your <Add New> after CHANGING that record creates a new blank
record, while over-writing what you originally had? If so, this is exactly
what you told Access to do.

A form based on a table, to start with, shows a record. When it displays
that record, any changes you make are made TO THAT RECORD. If you then tell
Access to add a new record, it starts a new blank/empty record.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
I think that you have the cart before the horse. Click on the Add New Record
button first. That should bring up blank fields on your form. Then add the
new record.
 
Back
Top