Main Form Data input, subform query to calculate

[wjm821]

Main form record source is tbl1 it has ParID,3 check boxes, 3 text boxes (enter a number). Subform record source qry1 (tbl1 & tbl2($$), ParID , $ for checkboxs, $ for text boxes, $total and both are linked with ParID. What I'm trying to do is if ckbox1 is checked, the query ckbox1 true then $$ (after Update) text 1 entered 5, query take 5*text 1 $(assume value$2) = $10. Query works if you're pulling from tbl1. The subform either shows total of the first record or it's completely blank.



Enter data in main form and have $$ show in subform with $$Total. Hope you can follow this and thank you for the help!

[June7]

Really should not need tbl1 in subform.

[Welshgasman]

Data entry is only allowing to add data.
You need correct data to link anything.

Look at PartyID 5.

[mike60smart]

It might help if you could explain the purpose of the database?

[mike60smart]

The Op contacted me via PM and I have given him a quick solution to his problem as shown in the attached.

[June7]

I don't even understand why this is two tables and not just one. Yes/No fields seem redundant.

A yes/no field is never Null - it is either 0 or -1. So the Nz() condition is not needed.
Simplify:
P1Sales: Abs([party1])*[party1fee]