"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)