Query problem

P

Pantelis

I have a form that I get some reports from a query.
In this form I have some droopdown lists and I make the compinations that I
want, I press the button and I get my report.
Now the problem I have is if I want from one or for some dropdown lists to
get all the informations and for others none I can't because I have to choose
from the list.
What I have to do to make this work.

Thank you
Pantelis
 
A

Arvin Meyer

Here's a query criteria for 4 combo boxes:

Like "*" & [Forms]![frmSearch]![cboFind1] & "*" And Like "*" &
[Forms]![frmSearch]![cboFind2] & "*" And Like "*" &
[Forms]![frmSearch]![cboFind3] & "*" And Like "*" &
[Forms]![frmSearch]![cboFind4] & "*"
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access
 
P

Pantelis

Hi,
I want to thank you for your help.
I will like to ask one more thing. I want to insert in a combobox the string
"ALL" and "NONE" and when I select ALL to get all the data and for none none.
But my compobox hane a table for source.

Thank you in advance
Pantelis

Arvin Meyer said:
Here's a query criteria for 4 combo boxes:

Like "*" & [Forms]![frmSearch]![cboFind1] & "*" And Like "*" &
[Forms]![frmSearch]![cboFind2] & "*" And Like "*" &
[Forms]![frmSearch]![cboFind3] & "*" And Like "*" &
[Forms]![frmSearch]![cboFind4] & "*"
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access

Pantelis said:
I have a form that I get some reports from a query.
In this form I have some droopdown lists and I make the compinations that I
want, I press the button and I get my report.
Now the problem I have is if I want from one or for some dropdown lists to
get all the informations and for others none I can't because I have to choose
from the list.
What I have to do to make this work.

Thank you
Pantelis
Click to expand...
Click to expand...
 
Top