J
JJurek
Hello All,
I figured I would pass this one by the throbbing brain and see what results
come up.
I have a form that has 2 dropdown boxes.
One is for a Licensing Specialist Name, the other is for the type of report
to display
(Types being P=Pending, W= Withdrawn, etc)
The IIF statement I am working with is listed below:
IIf([Forms]![Application Status Parameters]![CmbSpecialist]="ALL",[Licensing
Specialist].[Initials] Is Not Null,[Forms]![Application Status
Parameters]![CmbSpecialist])
What I am trying to do is pass the parameters to the Query, make a decision
based on user input and display the report. What I am attempting to
accomplish in the if statement is this: If the user selects "ALL", display
all the licenses for all of the licensing specialists else, display what the
user has selected.
The report runs, displays a few errors and no data.
Thoughts? Need more info?
-J
I figured I would pass this one by the throbbing brain and see what results
come up.
I have a form that has 2 dropdown boxes.
One is for a Licensing Specialist Name, the other is for the type of report
to display
(Types being P=Pending, W= Withdrawn, etc)
The IIF statement I am working with is listed below:
IIf([Forms]![Application Status Parameters]![CmbSpecialist]="ALL",[Licensing
Specialist].[Initials] Is Not Null,[Forms]![Application Status
Parameters]![CmbSpecialist])
What I am trying to do is pass the parameters to the Query, make a decision
based on user input and display the report. What I am attempting to
accomplish in the if statement is this: If the user selects "ALL", display
all the licenses for all of the licensing specialists else, display what the
user has selected.
The report runs, displays a few errors and no data.
Thoughts? Need more info?
-J