If Then statements

[QHRider]

I need to develop IIf Then statements, something like this:

IIf Question 1 = Yes, then go to Page Number. Else IIf Question 1 = No go to Dropdown.

Any help would be greatly appreciated.

Thanks,
QHRider

 

[Andrzejek]

IIf(Expression, TruePart, FalsePart)

so if you can have just Yes or No to your Question 1, then:
[tt]
IIf (Question 1 = Yes, go to Page Number, go to Dropdown)[/tt]

Have fun.

---- Andy

 

[dhookom]

QHRider,
Where do you intend to use the statement?

If [Your Expression] = SomeValue Then
    [COLOR=#4E9A06]'use statements here for True[/color]
  Else
    [COLOR=#4E9A06]'use statements here for False[/color]
End If

Typically IIf() is used as a function that returns a single value.

Duane
Hook'D on Access
MS Access MVP

 

[QHRider]

Andy and Duane,

Thank you very much for your input. I'll give them a try.

QHRider