Using the "Switch Function"

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sonfitz - 03 Aug 2006 15:29 GMT

I am trying to use the switch function to recognize a value in one
field,(USER ID), and based upon that value change the value in another feild,
(text box 43). The user id feild is a drop down type feild and the switch
function does not seem to recognize the values in the drop down field. I get
an error that says (Name?) in text box 43 field.

Is there a way to get that function to recognize values in a drop down type
feild?

Reply to this Message

Rick Brandt - 03 Aug 2006 16:54 GMT

> I am trying to use the switch function to recognize a value in one
> field,(USER ID), and based upon that value change the value in
[quoted text clipped - 5 lines]
> Is there a way to get that function to recognize values in a drop
> down type feild?

What expression are you using?

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Reply to this Message

John Vinson - 03 Aug 2006 18:35 GMT

>I am trying to use the switch function to recognize a value in one
>field,(USER ID), and based upon that value change the value in another feild,
[quoted text clipped - 4 lines]
>Is there a way to get that function to recognize values in a drop down type
>feild?

Two points:

- We cannot see your database, and have no way to tell what's wrong
with your Switch function since we can't see it. Coult you post the
expression?

- More important: if you can determine the value based on the UserID,
then you should almost certainly NOT be trying to store the value that
you're looking up/calculating in any other field; in fact the Switch()
function is probably not necessary, if you can create a Table to
provide the translation from userID to whatever the Switch() function
is intended to produce.

John W. Vinson[MVP]

Reply to this Message