If Then Else?

[Proaccesspro]

I have a form that has several pages to it. On the first page I capture 2 sets of names....On the third page I need to display the names that appear on the first page...The user has the option to leave one of the sets of names blank on the first page....I want to query the field on the first page to determine if it is blank, if so I want to insert the second set of names on the third page...I'm utilizing the expression builder in the control source box, but am unable to get the syntax correct......

my fields on the first page are:
1) Member First; Member Last, Patient First, Patient Last. Member First and Last are required fields; Patient first and last ARE NOT. On the third page I want to insert the patient first and last IF if was entered on the form. If not, I want to insert the member first and last. How would I write the syntax to do this??

[Rabbit]

You can use iif(Expression, Value if True, Value if False)

[Proaccesspro]

You can use iif(Expression, Value if True, Value if False)

Thanks for the reply...I saw this option, however I am having a hell of a time figuring the syntax to make it work. Would it be something like this?

Iif([member last]) <> null, [member last], [patient last])

[Rabbit]

Almost, in a query or expression builder you would use "Is Not Null"

[MMcCarthy]

Try this ...

IIf(Not IsNull([member last]),[member last],[patient last])

OR

IIf(IsNull([member last]),[patient last],[member last])

[NeoPa]

Thanks for the reply...I saw this option, however I am having a hell of a time figuring the syntax to make it work. Would it be something like this?

Iif([member last]) <> null, [member last], [patient last])

If you needn't worry about the 'First' fields, then the easiest method is :

=Nz([Member Last], [Patient Last])

[MMcCarthy]

If you needn't worry about the 'First' fields, then the easiest method is :

=Nz([Member Last], [Patient Last])

Clever Ade;)

[Rabbit]

Clever Ade;)

Indeed. Very nice.

[NeoPa]

If you DO need to worry about the 'First' fields, then please explain how they relate to the other fields.
If you need to get resulting strings using concatenation (&) then any tests for Null (IsNull() or Nz() will fail).

BTW Thanks Mary (& Rabbit).