D
DAW
Can this be done? I am attempting to develop a form with two subforms. A
user has the ability to enter a number (Est) in the main form (Tot Form).
Then I reference this input in a calculated control in a sub form (Ent Form).
Calculation is =Forms![Tot Form]![Est]-[hold1] (hold1 is a control in my
subform)
This calculated control is named Avail.
Then, whenever I attempt to perform other calculations based on this control
(Avail) - specifically summations in the subform footer section, I receive
#Error messages all throughout my form, even though controls are not related
to each other.
Thank you in advance!
user has the ability to enter a number (Est) in the main form (Tot Form).
Then I reference this input in a calculated control in a sub form (Ent Form).
Calculation is =Forms![Tot Form]![Est]-[hold1] (hold1 is a control in my
subform)
This calculated control is named Avail.
Then, whenever I attempt to perform other calculations based on this control
(Avail) - specifically summations in the subform footer section, I receive
#Error messages all throughout my form, even though controls are not related
to each other.
Thank you in advance!