Help! Form not updating data!

[mikewood1980]

Hello!

I have created a form with bound fields to enter data into several tables in my database. The form need to update 2 records in one table (tblWallLeaves) and update the IDs in the table tblWallConstructions. One wall construction can have many leaves (usually up to 2) and each leaf construction can be used in many wall constructions (hence the many to many relationship in between tblWallLeaves and tblWallConstuction).

I have tried to create a form with which you can enter information for 2 leaves for a particular wall construction but none of the data is updating in the tables (or the related IDs). I have attached a zip of the database completed so far.

Thanks for your help!
Mike

 

[ajetrumpet]

tblWallLeaves is probably the culprit.

You have two copies of a form that is sourced from an SQL statement, not a table. First of all, why do you have two copies of the exact same object on your form?

 

[mikewood1980]

Thanks Adam
We need two copies of the same subform (frmWallLeaves) as each Wall Contruction will have two leaves... to normalise the data we decided to store data for each "leaf" the wall contruction and reference them in the join...

Does this make sense? Are there any other ways round this? I was thinking maybe I should do all the form and data handling in VBA code (ie leaving all of the fields unbound)?

Thanks again for your help
Best wishes
Mike