VB Array

[bkrampe]

I am trying to write an expression in access that after an item in a drop down is selected, if its ex: (1,2, or 3) then have a lbl say "Non-qualified" else "Qualified".

I have looked through the whitpages but did not find anything, but im not totally sure what the name is that im searching for. In CR i believe its call an array. Thanks in advance

 

[HarleyQuinn]

Not sure about doing it for a label (you can do this using VBA) but if you don't want to use VBA and stick with just an expression, try something like this in the ControlSource of a Textbox:

=IIf([YourComboName]='1' Or [YourComboName]='2' Or [YourComboName]='3',"Non-Qualified","Qualified")

Hope this helps

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

http://lessthandot.com