Results won't save to table

E

Ed Lara

Hi:

I have a form that is calculating a formula. The formula
is working and the result shows on a text box. However,
when I go to the table to see if the result is being
saved, the table is blank where the result should be saved.

I took the formula out and placed in a dummy number. The
dummy number did save to the table.

Anyone knows what the problem may be?

Thanks.

Ed

The formula is this:

=IIf([ysnProhibited]=Yes,0,IIf([ysnIncomplete]=Yes,0,IIf
([check100]=Yes,0,[text45]+[Text51]+[Text54]+[Text58]+
[Text63]+[Text68]+[Text75]+[Text76]+[Text77]+[Text78]+
[Text79]+[Text80]+[Text81]+[Text82]+[Text83]+[Text84]+
[Text66]+100)))
 
R

Rick Brandt

Ed Lara said:
Hi:

I have a form that is calculating a formula. The formula
is working and the result shows on a text box. However,
when I go to the table to see if the result is being
saved, the table is blank where the result should be saved.

I took the formula out and placed in a dummy number. The
dummy number did save to the table.

Anyone knows what the problem may be?

Thanks.

Ed

The formula is this:

=IIf([ysnProhibited]=Yes,0,IIf([ysnIncomplete]=Yes,0,IIf
([check100]=Yes,0,[text45]+[Text51]+[Text54]+[Text58]+
[Text63]+[Text68]+[Text75]+[Text76]+[Text77]+[Text78]+
[Text79]+[Text80]+[Text81]+[Text82]+[Text83]+[Text84]+
[Text66]+100)))
Click to expand...

While it is normally a bad idea to save calculations anyway, what steps are you
taking to attempt to save it? If a TextBox contains an expression then by
definition it stores nothing in the table. In order to save values to the table
the ControlSource must be a field name in the table.
 
Top