Problem with macro...Please Help!

  • Thread starter Thread starter Don
  • Start date Start date
D

Don

All I need to do is Add theses fields togather ..but...
I can't seem to get this macro to work.
I am trying to display this total in a text box on my form.

Macro Name: CELLTOTL
Condition: TRUE
Action Name: SetValue
Arguments: [CELLTOTL], 57.46

Here is the expression in Macro: (All fields are currency)
=[BALANCEADJ]+[MOSERVICE]+[HOMECHARGES]+[ROAMCHARGES]+[OTHERCHARGES]+[NONCOM
MRELATED]+[TAXES]

I have even tried:
=Ccur([BALANCEADJ]+[MOSERVICE]+[HOMECHARGES]+[ROAMCHARGES]+[OTHERCHARGES]+[N
ONCOMMRELATED]+[TAXES])

I still get the same error on each field data entered although the data
posts to the form ok.
Any help I can get is appreacated


TIA
Donny
 
I do not understand what you intend with a "macro"
If you are trying to total these field entries on a form
you should create a textbox set the format for this
textbox to currency and enter the formula;
=[BALANCEADJ]+[MOSERVICE]+[HOMECHARGES]+[ROAMCHARGES]+
[OTHERCHARGES]+[NONCOMMRELATED]+[TAXES]
What kind of error are you getting?
Give some more information for some more help.
Fons
 
Back
Top