I am try to execute a query based on criteria from a form combo boxes. I select a date range, expense type and business or personal with no problem. When I add a source combo box to my query criteria, I get Enter Parameter Value. I do not know why this criteria is treated differently.
These work good
Like IIf([Forms].[SourcesSelect].[Cbx_RentalPersonal]="All","*",[Forms].[SourcesSelect].[Cbx_RentalPersonal])
Like IIf([Forms].[SourcesSelect].[Cbx_IncExp]="All",'*',[Forms].[SourcesSelect].[Cbx_IncExp])
<=[Forms].[SourcesSelect].[Cbx_YYYY_MM_End] And >=[Forms].[SourcesSelect].[Cbx_YYYY_MM_Beg]
Not good; Enter Parameter Value
[Forms].[SourceSelect].[Cbx_Source]