Form Fields Not Blank when Adding a New Record

[larocqgi]

When I want to add a new record to my MS Access 2007 database, using a form I designed using the form wizard, the fields in the next records are already populated. How can I fix this?

[Seth Schrock]

Do you have any default values set?

[larocqgi]

When I look at my property sheet for each unbound field, in the "default value" row, there is nothing. Should I be looking for a default value elsewhere?

[Seth Schrock]

There are two places that you can have default values: in the table and in the form/report. I don't know which one you checked, but I'll give instructions for both. For the table, open the table in design view and then click on the field that is being populated automatically. In the field properties on the bottom of your screen, there is a line for default value. For the form/report, open the object in design view, click on the control that is connected to the field that is being populated and view the properties for that control. In the data tab, there is a line for default value.

You might also check the form's OnOpen, OnLoad, OnResize, OnActivate and OnCurrent events. Each of these events occur (in that order) when a form is opened. It is possible that in one of these events there is some code setting a value to the controls.

[larocqgi]

I do not have default values in both my table and form. In the form "event" tab, I do not have the options "OnOpen, OnLoad, OnResize, OnActivate and OnCurrent events", but I do have an embedded macro under "after update". I do not know what this macro is. I did not put it there.