Form sub form query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database based on the events template but with a lot of
customisation. the Swithboard form has a subform on it the subform only Sums
the total of money made so far using the term =Sum([RegistrationFee]) this
works and gives me the correct total the only problem i have is when the
switchboard opens it does not display the total, but if i move the mouse over
the subform it displays the total. i have changed most settings in the
properties but i cannot find anything that changes this.
 
Try creating a new field on your your form. In the control source of that
text box enter your calculation, ex. =[Quantity]*[Price]+[Shipping Cost].
Then just name the text box what ever you want. In this case it's total.

Hope this helps.
 
Thanks, Sorry this did not to work i put a another field in to the sub form
and it created the same problem i had to wave the mouse over the field to get
it to calculate. i tried to put the field directly onto the switchboard not
using a subform but got an error back instead of a calculation.


jernatety said:
Try creating a new field on your your form. In the control source of that
text box enter your calculation, ex. =[Quantity]*[Price]+[Shipping Cost].
Then just name the text box what ever you want. In this case it's total.

Hope this helps.

Phil said:
I have a database based on the events template but with a lot of
customisation. the Swithboard form has a subform on it the subform only Sums
the total of money made so far using the term =Sum([RegistrationFee]) this
works and gives me the correct total the only problem i have is when the
switchboard opens it does not display the total, but if i move the mouse over
the subform it displays the total. i have changed most settings in the
properties but i cannot find anything that changes this.
Click to expand...
Click to expand...
 
Back
Top