I am trying to figure out forms for the first time today, and I had an issue where the form would always default with data already populated in the form entry fields with existing data from the table when you opened the form. Google helped me figure out how to solve that problem on my test database.
I went to my established database to try to create some forms, and I'm having the same issue with the form auto-populating the input fields with existing data from the table. I tried to fix this using the same steps as before, and the things it's telling me to look for and do are not available. The only difference between the two databases I noticed was that the fix worked on a brand new table, but not on an already established table. Here are the steps that worked on the new table, and where I'm having issues with the established table.
Problems:First off, go to the your form's properties and make sure the "Allow Additions" is set to "Yes".
Now go into your VBA code and in your Sub Form_Load() add the following statement:
DoCmd.GoToRecord , , acNewRec
This will open your form to a new/blank record.
Hope this helps!
1: I don't see the option for "Allow Additions" in the form properties for the established database / report.
2: When I Alt F-11 for VBA, there's nothing there at all. I can insert a module, and then it's literally the only thing in VBA for this database. I inserted that code into a new module, but the form still opens with data.
Google has been unable to help me fix this issue. Are any of you fine individuals willing and able to help me fix this?
Thanks for your time!
Bookmarks