Prevent record creation if form is null

[jaitken0308]

Hi everyone. I could use your help.

Nutshell: My user DB has one menu with 4 tabs (2 for adding records, and 2 for searching/editing records). Since the form opens up in the acFormAdd mode, Access already creates a new record (blank) before they type anything. It is resulting in blank false new records that are getting added to the table and they are getting annoying. My audit table is full of "user X created new record at this time" when it's just a blank record.

There must be a way to prevent this using VBA, but I cannot find it. :banghead:

I've seen ways to disable "add new record" buttons and such, but nothing that disables Access from being smarter than me and creating a new record before I decide to. I may just not know what keywords to search for to find this.

Any help is appreciated.

 

[RuralGuy]

Access does *not* create records unless you have changed something or are taking extraordinary steps. What make you believe it is Access that is creating the records?

 

[jaitken0308]

Because I don't want to be at fault...

Seriously, I'm not sure. Here's the best I can do to explain:
-When my DB opens, you have to login (using a form I created).
-After logging in, it takes you to the Main Menu (the one with 4 tabs). It opens in acFormAdd mode (is this the issue? and if so, how could it add records if I disable this?)
-I disabled the "SetFocus" off of the add record forms and moved it to one of the search forms (thought maybe since the focus was in a text box on an "add" form, it was starting to create the new record.)
-If I don't click through any of the tabs, no new records are created.
-If I do click on one of the "add record" tabs, it creates a blank record in the table. Every time. Doesn't matter if I actually type anything or not. As soon as I click on the tab to view it, the record is now created.

Any ideas?