Record being doubled in table?

[d9pierce1]

HI all,
I attached a sample DB from my actual as so I could figure out why this controls afterupdate event is adding two records for each entry. I have spent most of last night on it and this morning and cannot figure out at all. The real kicker is i have this code in another database and it works just fine.

Why is this doubling my records? db will open to CompanyFrm, then open CompanyLocationFrm and enter some info, dont worry about data. Then open up Company2LocationTbl and you will see it put two records in it.
Please assist
Thanks
DaveDBMeProfile.zip

[June7]

Why does CompanyLocationID field in Company2LocationTbl have a description of "From LocationTypeTbl" shouldn't that be "From CompanyLocationTbl"

Company2LocationQry is used as form RecordSource. When data is entered in form, a record is created in both tables because of links in query then code creates another record. Don't use query as RecordSource, just use CompanyLocationTbl.

As a general rule, a form should do data entry/edit for 1 table.

Use form/subform arrangement for multi-table input or use unbound forms/controls and code.

Not really understanding purpose of two location tables.

[d9pierce1]

Thanks June7
I found the issue. Actually there were two of them but got it fixed. I tore this db apart ....Now i get to put it back together with the fixes....
Thanks
Dave