Combo box and "ALL"

[hockeyfan21]

Hi,
I have a query that is run after selecting a parameter from my combo box that then is exported to an Excel template.

For my "All" selection I have the critieria as *. I cannot get the data to populate in Excel. I don't get an error mesage, it just comes up blank.

Also, if I just try to run the query on it's own it doesn't even give me the parameter box it just comes up blank.

My query is set to Forms!frmMain!cboType.

All other selections populate the template but this one.

Please let me know if you need additional info. Appreciate any ideas on troubleshooting.

Thanks,

Toni

 

[hockeyfan21]

Solved my own problem. I had to add "Like" in front of my criteria in my query. Like [Forms]![frmMain]![cboType].

Thanks!