Textbox controlsource depending on a table field

[Jen]

In a form where I have a calculated textfield, is it possible to let the
user choose between two ways how this field is calculated, from another
form/table field? The user would choose this "globally" so that it would
affect every new record.

In a settingstable one field is "addtax". Based on the value here (yes/no,
1-2, whole formula..?) the controlsource for the calculated textbox would be
determined. For example, i the "addtax" field in the settings table is "1",
the calculated textbox recordsource would be
"=[hours]*[hourlyrate]*[taxpercent]/100", if the "addtax" field in the
settings table is "2", the calculated textbox recordsource would be
"=([hours]*[hourlyrate])*(1-1/(1+([taxpercent]/100)))".

Tried IIf, tried to put the whole formula into the field, tried If Then
Else.. but without success.

Jen

 

[JohnFol]

Jen, you have 2 responses to your post yesterday under formscoding. . .