C
Casey
Dave,
For some reason, I could not send you the reply to
your posted message in the Microsoft Newsgroup earlier.
It kept failing on me. So, I sent you an e-mail to your
address in attempt to reply to your question. I am just
trying to give you this message via the newsgroup now.
The answer to your question is as follows.
Use the following in the query selection criteria:
Iif ([Forms]![frmMailOutput]![cbbProduct1]) is not null,
[Forms]![frmMailOutput]![cbbProduct1], [fieldname])
but use the field name that is the designated source of
that query column.
For your second column of criteria use the same thing
but resort to the [cbbProduct2] text box name instead of
the one mentioned above.
Casey
For some reason, I could not send you the reply to
your posted message in the Microsoft Newsgroup earlier.
It kept failing on me. So, I sent you an e-mail to your
address in attempt to reply to your question. I am just
trying to give you this message via the newsgroup now.
The answer to your question is as follows.
Use the following in the query selection criteria:
Iif ([Forms]![frmMailOutput]![cbbProduct1]) is not null,
[Forms]![frmMailOutput]![cbbProduct1], [fieldname])
but use the field name that is the designated source of
that query column.
For your second column of criteria use the same thing
but resort to the [cbbProduct2] text box name instead of
the one mentioned above.
Casey