You can use a single combo with "All" as an option:
http://www.theaccessweb.com/forms/frm0043.htm
and this to use the null value of "All" to return all:
http://www.theaccessweb.com/queries/qry0001.htm
I am using a single combo box with "All" as the first option........just dont know what to use in vbs condition to rn the report
If the bound value is null, as suggested by the first link, you don't need any code, just the criteria shown in the second link. This is just one of many ways to do this. I'd probably go with a VBA solution, but that's because I'm comfortable coding it.
Did you try query syntax suggested in post 6?
Otherwise, for VBA code to construct filter criteria, review http://allenbrowne.com/ser-62.html
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.