I've done all the research I can do on the issue I'm having. I've got a subform with 2 calculated fields on it:
subform: frmJobDetails (datasheet view)
detail field 1: txt_price_extended
recordsource = Format([QTY]*[Price],"Currency")
detail field 2: txt_units_extended
recordsource = [Units]*[QTY]
footer field 1: txt_price_subtotal
recordsource = Sum([QTY]*[Price])
footer field 2: txt_units_subtotal
recordsource = Sum([Units]*[QTY])
main form: frmJob (single form view)
field 1: txt_cost_extended_from_frmJobDetails
recordsource = Format(frmJobDetails.Form!txt_price_subtotal,"Curr ency")
field 2: txt_units_extended_from_frmJobDetails
recordsource = frmJobDetails.Form!txt_units_subtotal
Hopefully that's enough to give you a visual...
The problem is, if I assign the recordsource to footer field 2 as above, I get the dreaded #error in BOTH footer field 1 and footer field 2. If I just run with the "price" fields set up (with no recordsource assigned to the "units" footer field) they work as expected. I'm at a loss here guys, please end my misery! In a nutshell, 1 calculation and echo to main form works great... 2 calculations and echoes causes both to not work?
Could it be this in conjunction with the inline editing bug? ...
If you go to edit a subform while it is on your mainform in design mode, you select a subform object (like a text box) to edit it and it looks selected, but the property sheet is giving you the subform's FORM properties, no matter what is actually selected. Combine that with your apparent confusion between ControlSource and RecordSource and you might actually be inadvertently changing the RecordSource for the form instead of the ControlSource for the control.
If it's not that, then I am at a bit of a loss... with this configuration, setting a control source for footer field 2 should not affect footer field 1.
You are very correct in the references to csource and rsource...In the heat of trying to describe my problem, I mis-typed. Anyhow, I meant to say controlsource, and they are referenced correctly in my forms. As far as selecting the control in the subform, rather than the subform itself, we're good there too. I have also tried editing directly from the subform "native" form...to no avail! Any other thoughts?
Ah, I don't think you can do that... you have a subform which has a subform and you are also showing the datasheet view. I'm not sure you can reference the Form! object from a form which is in datasheet view. Not sure though because I NEVER use datasheet view
I suggest you make a separate form for your subform object rather than using a mainform with a subform as a subform.
You also have a couple of references that are not standard... something about flexigrid... that I had to take away to get the form to even run