switch statement calculated field on a continuous form

  • Thread starter FilemakerPro_Developer
  • Start date
F

FilemakerPro_Developer

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,
 
V

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DLookup in Continuous form 0
need a continues form 0
Filtering and summing a calculated field on a subform 0
Sum IIf Statement Values on form 1
Set form field on double click 3
Calculated field in a table 6
Add New Table to Existing Form (Access 2003) 3
Continuous form field value 0

Top