switch statement calculated field on a continuous form

[Guest]

I used this switch statement in a field in a query. I base a calculated
field in a continuous form on this field. It doesn't calculate. Furthermore
it asks for the PartyID parameter twice before opening up the form. for each
record in the list I just want it to list whether it is for the respondant or
appellant.
Expr1:
Switch(Tables!tblEvaluations![PartyTypeID=1],"Appellant",Tables!tblEvaluations!PartyTypeID=2,"Respondant")
Is something wrong with the expression or the query?
thanks,

 

[Van T. Dinh]

The square brackets seem to be incorrectly placed ...

Is Table [tblEvaluations] one of the Tables in the DataSource for your
Query?

If it is, try:

Expr1: Switch(tblEvaluations.PartyTypeID=1, "Appellant",
tblEvaluations.PartyTypeID=2, "Respondant")

If the possible values of PartTypeID, you may be able to use Choose() also.
Check Access VB Help on Choose() function.