Newbie question

[Patience]

Hello all,

I have a very basic issue here I guess. I hope you can help me.

I want the following to happen:



From a form the user can chose between multiple checkboxes. More than one checkbox can be ticked at the same time. I want the choise of checkboxes to determine which data from a table should be used in a report.

I have made the form, the checkboxes, the table and the report. But how do I make a query that allows me to make multiple filters in the same table based on the ticked checkboxes???

Thanks in advance.

[ConneXionLost]

Set the criteria in your query to be the value of your checkboxes.

e.g.

[Forms]![YourForm]![YourCheckBox].[Value]

[Patience]

I simply can not get it to work. Allow me to be more specific:

Table name: T1
Form name: F1
Checkboxes located at F1: C1, C2, C3
If C1 is ticked: "Cars" records from T1 are included in the query results
If C2 is ticked: "Bikes" records from T1 are included in the query results
If C3 is ticked: "Trains" records from T1 are included in the query results

Multiple checkboxes can be ticked at the same time.

How exactly should my query look like in order to do this? I have upgraded to 2010, so please write the expressions in the propper "language".

Thank you very much in advance!

[ConneXionLost]

You didn't say what the name of your field is in T1, so you'll need to add it in place of "YourFieldName" in this query:

SELECT T1.*
FROM T1
WHERE (((T1.YourFieldName)=IIf([Forms]![F1]![C1]=-1,"Cars","") Or (T1.YourFieldName)=IIf([Forms]![F1]![C2]=-1,"Bikes","") Or (T1.YourFieldName)=IIf([Forms]![F1]![C3]=-1,"Trains","")));

Ensure this query is used as the source for your report.

[Patience]

Thank you for your suggestion. I've tried it, but I still can't get it to work.

When I read about the IIF it seems that it only returns one value depending on whether it is true or false.

What I want to do is to have all records beginning with e.g. "Cars" to be shown in the query result. But no matter what I write, the result is an emty list.

I've tried with:

WHERE (((T1.Text)=IIf([Forms]![F1]![C1]=-1,"Cars*","")));

WHERE (((T1.Text)=IIf([Forms]![F1]![C1]=-1,Like "Cars*","")));

WHERE (((T1.Text)=IIf([Forms]![F1]![C1]=-1,Like ("Cars*)","")));

And many more.

Any ideas?

Thank you very much!