Syntac Error When new record afterupdate event

[d9pierce1]

Hi all,
I have attached db and when i try to add a new address i get an error. I have spent two days trying to figure this out but i cannot find a solution to this.
CompanyProfileFrm needs to be open first, then CompanyAddressFrm to add a new address to the company and location

The qry works but i cant get rid of this error and wont let me add a new address to this. Please assist if you would.
I had to remove most all data from this db to get it to allow me to add here! Data is limited,
Thanks

DavedbProfileNew - Copy.zip

[CJ_London]

what is the error number and description?

[Bob Fitz]

Hi all,
I have attached db and when i try to add a new address i get an error. I have spent two days trying to figure this out but i cannot find a solution to this.
CompanyProfileFrm needs to be open first, then CompanyAddressFrm to add a new address to the company and location

The qry works but i cant get rid of this error and wont let me add a new address to this. Please assist if you would.
I had to remove most all data from this db to get it to allow me to add here! Data is limited,
Thanks

DavedbProfileNew - Copy.zip

I'm not sure that your tables are structured properly. Can you explain what each one is for and how they are related

[d9pierce1]

This is the error however i do get a syntax error following 3134

[d9pierce1]

Thanks,
The AddressTbl Stores All Addresses and Address Info such as Address Type, City, state, ZipCode, and County
The LocationTbl stores the company location info
The Company2AddressByLocationTbl stores CompanyLocationID and the AddessID (ManytoMany) Sort of
What i am looking for is to be able to have multi address for one companytype, Such as the company I work for has mutli locations. I want to have multi addesses and address types per location.
Hope that makes sense!

[d9pierce1]

Better Description!
I had to remove a lot of things from this db to be able to post here so some a lot of data and tables have been removed. Current tbl,qry and frm are related to this issue.

CompanyTbl Stores company names...and not related misc to this issue.
CompanyLocationTbl stores CompanyLocationID,CompanyID, Location and non related
AddressTbl stores AddessID, AddressTypeID, Address info and City, State, ZipCode, and County along with other non related...
Company2AddressByLocation is many to many tbl, Where stores the AddressID and the CompanyLocationID
CompanyLocationQry populates the CompanyLocationFrm. That works well, no errors...
Company2AddressByLocationQry populates the CompanyAddressFrm and that where we have issues.

Once I select an AddressType from the CboAddressType, i get the above error? It should begin new record, then the after update event should fire and put the AddressID and CompanyLocationID in the Company2AddressLocationTbl? I normally get a syntax error after that fires for some reason.

I beleive i have something wrong with the Location? I need to have multi address per company locations and multi locations for one company. The Query for the CompanyAddressFrm seems to display the correct info, yet will not allow me to make a new record?
I have no idea what is going on with that.

Thank you
Dave

[d9pierce1]

Thanks all,
I found a solution so hopefully it will work correctly again!
Dave