Dirk,
That was it exactly. It works exactly as I want it to now. Thanks for your
time and expertise!
Cathy

"Dirk Goldgar" wrote:

"cathyt" wrote in message
...
Dirk,
The values are as follows:
SIGNWORK:
1. (Value List)
"None";"Install";"Replace";"Repair";"Remove";"Relo cate";"Relocate &
Replace";"Relocate & Repair"
2. one
3. one
4. blank

FACETYPE
1. (Value List) “High Intensity”;”Diam. Grade”
2. one
3. one
4. blank


Somehow we've got "smart quotes" in some of those values, and in the IIf()
expression -- things that look like simple double-quotes when view as plain
text, but aren't. Edit your rowsource lists and replace all quotes with a
freshly typed " character, and do the same with the ControlSource
expression. When I do that in a test form, it all works fine.

--
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

(please reply to the newsgroup)