By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,984 Members | 2,832 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,984 IT Pros & Developers. It's quick & easy.

Form Fields Not Blank when Adding a New Record

P: 23
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?
Dec 7 '11 #1
Share this Question
Share on Google+
4 Replies

Seth Schrock
Expert 2.5K+
P: 2,941
Do you have any default values set?
Dec 8 '11 #2

P: 23
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?
Dec 8 '11 #3

Seth Schrock
Expert 2.5K+
P: 2,941
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.
Dec 8 '11 #4

P: 23
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.
Dec 8 '11 #5

Post your reply

Sign in to post your reply or Sign up for a free account.