B
Betsy
this seemed so easy when I first started, but everything I tried has not
worked.
I have a database with a form: form1 and a subform: subform1
the subforms are connected to the form by the SchoolID
each school form will have a subform for each month.
the subforms contain many numbers and calculations which seem for the moment
to be working. I have a total field on each subform which I will need to sum
and add to the parent form as a grand total. since I cannot SUM calculated
fields I figured I would just pass the value into another field on the
subform that I could then SUM.
Currently I have built andexpression in the AFTER UPDATE field that says:
Me![subform1].Form![new ref] = Me![subform1].Form![tot ref]
This will not pass the value to the new_ref field.
then I figured I'd add some code to the field on the form that says:
Me!Referrals_to_date = [subform1].Form![new_ref]
I haven't tried this yet as i can't get the first code to work, but would
that be the way to go?
worked.
I have a database with a form: form1 and a subform: subform1
the subforms are connected to the form by the SchoolID
each school form will have a subform for each month.
the subforms contain many numbers and calculations which seem for the moment
to be working. I have a total field on each subform which I will need to sum
and add to the parent form as a grand total. since I cannot SUM calculated
fields I figured I would just pass the value into another field on the
subform that I could then SUM.
Currently I have built andexpression in the AFTER UPDATE field that says:
Me![subform1].Form![new ref] = Me![subform1].Form![tot ref]
This will not pass the value to the new_ref field.
then I figured I'd add some code to the field on the form that says:
Me!Referrals_to_date = [subform1].Form![new_ref]
I haven't tried this yet as i can't get the first code to work, but would
that be the way to go?