Using wildcard * in a combobox on form to generate report

[drrep]

Hi,

I have a combo box in my form. Now I have 5 values in there including a value called ALL. I want that ALL to display all the data in a table, and not filtered by a specific value.
(like saying SELECT * from table)

Problem is that when I select ALL from the combobox, I change the value of the combobox to * for the query to pick up all data but then I get nothing as results in my report.

If I go to the query itself, and enter * in the criteria where I specified Like [Forms]![Testform]![ComboField] , it works just fine

Any ideas?

 

[essnrv]

1.Create a query like "Select * from table1" and assign to report.
2.To filter the result based on selection.
In Report_Open Event Check for User selections.Below is Example.

strFilter = "[TransDate] Between #" & Forms![yReport Selection Screen]![From Date] & "# "
strFilter = strFilter & "AND #" & Forms![yReport Selection Screen]![To Date] & "# "
If Trim(&quot;&quot; & Forms![yReport Selection Screen]![Selection Criteria]) <> &quot;*&quot; Then
strFilter = strFilter & &quot; AND [ItemNumber] = '&quot; & Forms![yReport Selection Screen]![Selection Criteria] & &quot;'&quot;
End If
Me.Filter = strFilter
Me.FilterOn = True

Note:Assuming your report selection form is loaded