Re: Form Criteria for Query to generate Report
- From: "tina" <nospam@xxxxxxxxxxx>
- Date: Sat, 08 Apr 2006 04:20:07 GMT
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 aa
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
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
.
- References:
- Form Criteria for Query to generate Report
- From: Peter
- Form Criteria for Query to generate Report
- Prev by Date: Re: Trying to filter records with combo box
- Next by Date: Re: Listbox displays Primary Key
- Previous by thread: Form Criteria for Query to generate Report
- Next by thread: Trying to filter records with combo box
- Index(es):
Relevant Pages
|
