Re: Form Criteria for Query to generate Report

set the criteria in the query's country (for instance) field to

[Forms]![FormName]![ComboBoxName] Or [Forms]![FormName]![ComboBoxName] Is
Null

the above goes all on one criteria line in the query design grid; and
substitute the correct form name and combo box control name, of course.
repeat the syntax for each criteria that refers to a control on the form.

hth


"Peter" <takisa@xxxxxxxxxxx> wrote in message
news:UOCdnc_BSMWwjarZnZ2dnUVZ_s2dnZ2d@xxxxxxxxxxxxxx
I have created a form that feeds a query, and automatically generates a
report based on the choices I've made on the form.

The form contains a few combo boxes that offer all of the available (for
example) categories, countries, Reps, etc.

Everything works fine, however there is a little glitch. I have to select
a
field from the combo box. If I leave it blank then I get no data.
So, If I want to view all of the countries or all of the customers, I
can't - I have to select a specific one from the drop down list.

Is there a wild card or value that I can input in the drop down box that
will allow me to view everything (all of the categories or all of the
countries)?.

Thanks in advance
Pete




.

Relevant Pages

  • Re: Cubas march to nowhere
    ... Cuba still is a net importer of food. ... FAO's Low Income Food Deficit Countries are based on three criteria: ... applied to countries included in World Bank categories I ...
    (soc.culture.cuba)
  • Re: Aflac zed?
    ... shot at lac zeta. ... how many countries outside of the EU actually qualify for the Lac ... Failed the criteria. ... the last two being borderline candidates. ...
    (rec.sport.soccer)
  • Re: Eight countries are waiting to join the European Union.
    ... >>> Bulgaria and Romania have signed accession treaties and are set to ... >> This another thing that would tick me off if I were living in one of the ... >> criteria. ... The deal was that these countries can join in 2007 if they ...
    (rec.travel.europe)
  • Re: Penetrating the Chinese firewall
    ... Every country in the world has its own criteria of what is to be ... of other countries is nonsense, and you either know that (in which case ... Your knowledge of things Chinese is *infantile*, but no, the Chinese ... China has been the most advanced culture in the world for the last ...
    (soc.culture.china)
  • Re: Conditional formatting changes field enabled property?
    ... The CF routine can only handle 3 criteria. ... Your conditional formatting VB code almost ... "Stephen Lebans" wrote: ... applied, on a Control by Control basis, based on the criteria YOU set. ...
    (microsoft.public.access.forms)