Query questions (SQL statement) Listbox versus Subform

J

Jazz57

hi everyone:

i have a form that is supposed to display my records in a large variety of
ways.
To sort them i have 3 combo box (Cmb1 , Cmb2, Cmb3), 2 datetime Picker(DTP1,
DTP2) and 6 checkbox (Chk1, .... Chk6, in order to control which field i
wanna see).

to display those fields i made a query and a listbox in the first place. ( i
don't really know if is the best solution. A subform wouldn't be better ?)

Anyway:

1. if i don't fill any of them, it just display the all data according to
my query

2. But when i fill one of them i want the data to be sorted according to my
selection.

i am having a lot of problems with the SQL instructions.

and until now i only could achieve one compromised solution. I only can
retrieve the data if I only fill one of the ComboBox....

i want a combination of them and i don't wanna to make a query with
parameters in order to the user fill the parameter of each field

Maybe i am trying to reach the impossible...

Those anybody can help with this issue

Any kind of help will be wellcome

Thanks in advance to all of you
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to populate a listboc with the result of two combobox 14
Printing SQL query results in a list of columns, instead of one long column 1
Need help getting query to reference a field in a subform 2
Multi-criteria drop down link to subform 0
Modifying subform's underlying SQL statement 2
Problem with queries and linked SQL Tables 2
Order By in Query Spuriously Filled In 1
SQL Code Help 2

Top