Choose Function

[d1004]

Can somebody help me explain how the choose function works.
Code:
Choose([ServiceCenters]![ID],15,30,46,61,0,0,0,0,0,0,95)

If this code is in an update query, and the criteria are met, then it will choose one of this value and updated in the ID field of the ServiceCenters Table?

 

[RickSpr]

What is it about the Help topic that you don't understand? It seems quite clear to me. Rick Sprague
Want the best answers? See faq181-2886
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein

 

[Darrylles]

Hi d1,

(Very subtle Tek-Tips (and sneaky)).

Choose basically contains the values that your [ServiceCentres]![ID] may contain.

You should use it like this:

=Choose([ServiceCenters]![ID],15,30,46,61,0,0,0,0,0,0,95)

in a text field control source property.

You are basically limiting the possible values allowed in this field. (As far as I can see).

(I hope Rick the explains it all for us - lol).

Regards,

Darrylle "Never argue with an idiot, he'll bring you down to his level - then beat you with experience." darrylles@totalise.co.uk