Option Box to change record source

[Chris B via AccessMonster.com]

Hi,

I have an option box with 3 values that when selected changes the record
source based on tasks completed and not completed, this works fine(I have
this code in the Criteria of the [Tasks] tick box.
Also I have the form requering after the option box is updated, so info is
current and correct...

IIf([Forms]![frmEmployees]![Calls].[Form]![Frame13]=1,No) Or
IIf([Forms]![frmEmployees]![Calls].[Form]![Frame13]=2,Yes)

I would like to get the 3rd option to display ALL ie both YES and NO, I have
tried

IIf([Forms]![frmEmployees]![Calls].[Form]![Frame13]=3,"")
also tried IIf([Forms]![frmEmployees]![Calls].[Form]![Frame13]=3,"Yes" and
"No")
I just cant seem to get it right, the errors on trying for option box Value 3
is on of the "calculation is too completed"

Im think I must be using ""

I have looked at other threads but cant seem to find one relevant to my
problem,

Any help is really appreciated!!

 

[Guest]

IIf([Forms]![frmEmployees]![Calls].[Form]![Frame13]=1,No,IIf([Forms]![frmEmployees]![Calls].[Form]![Frame13]=2,Yes,All))

 

[Chris B via AccessMonster.com]

Thanks Dennis for the quick response,

I tried it but I get an error saying that there are too many closing
Parethesis, I have tried working on the brackets but just cant get it right...
..

IIf([Forms]![frmEmployees]![Calls].[Form]![Frame13]=1,No,IIf([Forms]![frmEmployees]![Calls].[Form]![Frame13]=2,Yes,All))

Hi,

[quoted text clipped - 22 lines]

Any help is really appreciated!!

 

[Guest]

I don't understand why. There are 2 open parenthesis, one for each IIf and so
2 closing parenthesis at the end.

Thanks Dennis for the quick response,

I tried it but I get an error saying that there are too many closing
Parethesis, I have tried working on the brackets but just cant get it right...
..

IIf([Forms]![frmEmployees]![Calls].[Form]![Frame13]=1,No,IIf([Forms]![frmEmployees]![Calls].[Form]![Frame13]=2,Yes,All))

Hi,

[quoted text clipped - 22 lines]

Any help is really appreciated!!