RE: "Select All" in combo box for query

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Try this in criteria --
Like IIF([Forms]![YourFormName]![CpomboBox] <> "All Plant",
[Forms]![YourFormName]![CpomboBox], "") & "*"


--
KARL DEWEY
Build a little - Test a little


"buscher75" wrote:

I have an unbound form created to run a query/report. I have a combo box
that selects the department to be queried and I want to add "All Plant" to
the list of departments. This way a report can be generated by department or
plant wide. I've added "All Plant" to the list but do not know how, when
selected, to convert the words to a blank field within the query. Thanks in
advance for the help.
.

Relevant Pages

  • Re: Multiple Search Criteria with AND/OR???
    ... Plant Type1 ... "or" search criteria without having to specifically identify the criteria in ... Doug Steele, Microsoft Access MVP ... Dim strWhere As String ...
    (microsoft.public.access.formscoding)
  • Re: Query from field w/multiple values
    ... > What I mean is can I enter multiple criteria in the same criteria request? ... > For example I have a query that asks for a plant code. ... > to enter any number of plant codes they need in the same criteria field. ...
    (microsoft.public.access.queries)
  • Re: Help needed with Date Add function
    ... SELECT Plant,, Scale ... you need to add a calculated field ... Criteria: < DateSerial),Month)+1,0) ...
    (microsoft.public.access.queries)
  • Silver birch or like recommendation please!
    ... We want to plant a couple of feature trees, like silver birch. ... The criteria are: ...
    (uk.rec.gardening)
  • Re: Plant Finder Software?
    ... Now if someone created an online plant database searchable by different ... criteria as the original poster suggested, ... Now there's a business idea for someone. ... What is needed is a hybrid between a businessperson, gardener and software ...
    (uk.rec.gardening)