Search results

Hmm, that link feels like the right track, thanks!

There is a WHERE condition in the main form record source, yes: SELECT * FROM tJobsTotals WHERE [ControlNumber]=1; Would that screw something up?

I have a complicated form with several subforms, everything works as it should. I added one field to the table the main field is based on, then I destroyed and recreated the link between the table and the field. I added the new field to the main form and it shows up as it should, I did nothing...

Ah, that was it! It seems like it should just update dynamically so it never occurred to me to try that. Thanks so much, victory is mine!

Ok, I honestly have no idea what the problem is here, but it's giving me show-stopping errors and I need some help. In my program if I try to either add a field to a table or change the name of an existing field, I cannot reference the new field in the code, I get an error (usually "Variable...

That's the weird part, in the database and screenshot that I posted, I am using the method for the items as well as the payments, yet it's giving me different results. In fact, as far as I can tell both totals fields are set up exactly the same. It's all very strange, and rather frustrating.

This basically works, although for some crazy reason the 0 in the first form doesn't actually show up, although the Grand Total now does the calculations correctly. I've attached a screenshot and a copy of the DB, thanks for everyone's help so far, I feel like the answer is just around the next...

I tried using that function with IsNumeric and an IIF statement, but to no avail. I even made an unbound text box =Sum([Total]) and then an IsNull test on that box to give me the 0, but that also didn't work. Here is a picture of the form, as you can see both Total Items and Total Payments are...

I have a form that opens with 2 empty subforms (items and payments) that later get filled in. Each subform keeps a running total of the items they contain, then the parent form holds the grand total of both. No matter what I do, I can't get the subform totals to show up as 0 when the subforms...

It's likely that there is something simple that I am missing, but I have been banging my head against the table all day with this: I have a form that needs to calculate the total based on the changed values in a subform. The subform changes and recalculates correctly, however the text box on...