Why am I getting an extra record

[Liz_I3]

Hi
I have an User ID filed on my form that populates when the form is opend to the users logon ID.

On the form I have an add records button. Each time the button is clicked it added the current record plus one with just the userID...why? It always addes this extra record. I assume it has something to do with the UserID being auto populated, but how can I stop it?

I have tried DoCmd.CancelEvent in various places On Dirty On after update etc but it did not help

Thanks
Liz

 

[Norie]

Liz

Perhaps the form is automatically adding the record?

 

[Liz_I3]

You are correct. My issue is I don't know how to stop it? I always get 1 extra record added to my table. The extra record is blank excetp for the UserID which just happens to be the field that is auto populated on load

L

 

[Liz_I3]

Just an update...
I stopped the auto populate field and access is still adding a blank line to my table every time a close my form

 

[Norie]

Even when you don't add a new record?

 

[Montez659]

So, if the form is bound to a table, do you have code in VBA anywhere that updates a field when a New Record is populated? If so, then what I am envisioning is happening is that the form loads up, VBA code is run and a field is changed, Access automatically creates a new record. Then, you are pressing a button to add a new record, and so a new record is added after the one that was just altered somehow (be it by VBA or something else). So you are getting two records because when the form loads up, a new record is automatically created.

Hope that makes sense. What you could do is include some form validation measures to make sure that all required fields are filled out before allowing the record to save. This would ensure that a record is completed before saving.