"Jacques Latoison" Jacques Latoison at hotmail dot com wrote in message
...
Ok. I put this:

[Forms]![YourForm]![cboYourCombo] OR ([Forms]![YourForm]![cboYourCombo Is
Null])

into the criteria field of the query and saved it. When I re-opened it in
design view. It only showed this:

[Forms]![YourForm]![cboYourCombo]

and everything after the OR was turned into another field at the end of
the columns in the query, with IS NULL in its criteria.

Opening the form shows everything, initially. Choosing an item in the
combo box now clears the forms lists completely. In other words, it now
does the exact reverse - gives me everything or nothing.
I have to admit, I thought it was funny.


That implies that there is no record that matches the combo box. If you
think that is not correct, please post the SQL view of the query, the actual
name of the form, and the following properties of the combo box:

Name
Row Source
Bound Column


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

(please reply to the newsgroup)