m17347047711116
Registered User.
- Local time
- Today, 04:01
- Joined
- Feb 4, 2002
- Messages
- 68
Have an option group with 3 department options
would like to have a unbound box on my form use the Choose() function to convert the option group value to corresponding text value, then have my query criteria point to the unbound box for what department to print the desired report for.
but i can't remember how to use the choose function
in the control source i have typed Choose()"Printing","Shipping","Converting"
But it does not list the department in the unbound box when i select the desired option group.
i know i am very close to the right code but i can't get it
any help would be appreciated
would like to have a unbound box on my form use the Choose() function to convert the option group value to corresponding text value, then have my query criteria point to the unbound box for what department to print the desired report for.
but i can't remember how to use the choose function
in the control source i have typed Choose()"Printing","Shipping","Converting"
But it does not list the department in the unbound box when i select the desired option group.
i know i am very close to the right code but i can't get it
any help would be appreciated
