IIF statement based on Yes / No selection on form

[Thomas Hardy]

Hi,

How can I get a query to take the value of a checkbox on a form into account
in a formula?

The checkbox may read Yes or No at the time you click on button on the same
form to trigger the calculation, and then some of the formulae will refer to
this in the calculations, e.g.:

IIF(checkbox is checked, Calculation A, Calculation B)

Thanks very much

Thomas

 

[Pat Hartman]

If Me.YourCheckbox = True Then
Me.YourResult = calc1
Else
Me.YourResult = calc2
End If

 

[Ken Snell [MVP]]

You're wanting to do this in a query, correct?

You would use an IIf statement like this:

IIf(Forms!FormName!CheckboxName=True,Calculation A, Calculation B)

 

[Thomas Hardy]

Thanks Ken,

That's exactly what i was looking for.

Thomas

 

[Ken Snell [MVP]]

You're welcome.

--

Ken Snell
<MS ACCESS MVP>

Thanks Ken,

That's exactly what i was looking for.

Thomas