Question appropriate on usage of Choose Function

[justphilip2003]

=Choose([PoliticalPreference],"Democrat","Independent","Non Voter","Tea Party","Republican”)



I still can't resolve the problem with this code, but I am wondering about its use in a report control source since it doesn't stop with a match, but tests each choice. Seems to me that this would extend the run/print time. Any thoughts on using this function in preference to the other selective Functions? TIA Phil

[pbaldy]

Seems like you already know the answer: a related table. I can't remember the last time I used Choose() in an app.

[ssanfu]

Phil,
As far as I can tell, the last quote is the wrong quote character:

=Choose([PoliticalPreference],"Democrat","Independent","Non Voter","Tea Party","Republican”)

Try this:

=Choose([PoliticalPreference],"Democrat","Independent","Non Voter","Tea Party","Republican")

[justphilip2003]

Thanks, I need to look into enlarging my screen print!! I think I also have a data type conflict here. PoliticalReference is assigned a value through an Options Group Button. I learned while playing with another example code that my values were defined as text not numeric in the Table. So I am thinking that Choose will not work here. If I change the table to integer, then my IIf and Switch examples will probably cease to work. TIA Phil

[ssanfu]

If I change the table to integer, then my IIf and Switch examples will probably cease to work.

They will cease to work until you change the arguments from a "text 1" to a "number 1".

Text 1 looks like >> "1"
Number 1 looks like >> 1

If you have problems, post back.