Form ComboBox Filter - Select ALL records

[jhrBanker]

I'm trying to filter records on a form with a ComboBox, and I want the option to return ALL records.
My Form is: frmReview
My ComboBox is: cmbGLimpact
The RowSource is: SELECT DISTINCT [GLimpact] FROM Initiatives UNION SELECT Null As AllChoice FROM Initiatives ORDER BY [GLimpact] DESC;
The Query Criteria is: [Forms]![frmReview]![GLimpact]
The field values are: Yes, No & TBD

The filter works fine for Yes, No & TBD, but the blank choice doesn't return all records.

I need to be able to setup several filter ComboBoxes to enable filtering on several different fields. So, depending on which ComboBox filter (field) the user wants to filter on, the others will allow all records to be returned.

Anybody know why this isn't working?

[June7]

Need wildcard:

Like [Forms]![frmReview]![GLimpact] & "*"

Review: http://datapigtechnologies.com/flash...tomfilter.html

[jhrBanker]

Need wildcard:

Like [Forms]![frmReview]![GLimpact] & "*"

Review: http://datapigtechnologies.com/flash...tomfilter.html

I made the changes above (adding "Like" and & "*") and it still didn't work. But after watching the video, I added a "Clear Filter" command button, and now it works.

Thanks for your help. Muchly appreciated.