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