Fred,
I have included this as my criteria for the division field of my query.
Like IIf([Forms]![query form]![cbodivision]="(All)","*",[Forms]![query
form]![cbodivision])
But I am not getting anywhere.
I use cbodivision as an input to multiple queries depending on the
button that is clicked. One button works fine when I select (All). The
other does not. When I tried to make the query for the one that does
not work match the structure of the one that does, I get an error in my
docmd line.

For the query that works
I created a new field: [Forms]![query form]![cbodivision] with "(All)"
as the criteria - with all of the other criteria blank. The other
option within this criteria has
[Forms]![query form]![cbodivision] as the criteria for the "Division"
field.

This same approach is not working in the other query - which is much
more complex.