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

Thanks,
Cathy

"Dirk Goldgar" wrote:

"cathyt" wrote in message
...
Peter and Dirk,
Thanks for your replies. I've tried both suggestions and for each get an
error message: Expressions contains Invalid syntax; may have entered an
operand without an operator.

It's always possible I made a mistake in my expression, but I'm not seeing
it. You mentioned that [SIGNWORK] and [FACETYPE] are combo boxes. What are
the values of these properties for each:

Row Source
Bound Column
Column Count
Column Widths


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

(please reply to the newsgroup)