Trying to filter a report by using a form. I went step by step through the instructions via the help screens. So everything is OK until I test the work I did. I get a message that reads
The expression you entered has a funtion that ProgramNameHere cant find
After reviewing my work everything appears to be done correctly, except for my filter criteria. The instructions read
For example, in a Microsoft Access database (.mdb), for a form called Sales Dialog, you would use the following expression to refer to controls named Beginning Date and Ending Date in the query:
Between [Forms]![Sales Dialog]![Beginning Date] And [Forms]![Sales Dialog]![Ending Date]
I of course changed mine to fit my progam and tried
[forms]![birthday report by month]![Month]
The instructions are from date to date. I need a single value.
So did I enter the criteria wrong or something else?