I have one form called rptDocRegister and amongst the fields reported is one called [DocTypeID]. The field holds numerical (7 for policies, 8 for procedures, etc)
I am using Navigation Form with a button with the Target Name as the report - it calls the report just fine.
I have tried the following statement in the Navigation Where Clause and NONE narrow the report to just type 7..
- = "[DocTypeID] = 7"
- "[DocTypeID] = 7"
- [DocTypeID] = 7
- "[DOcTYpeID] =" & 7
How do i get this to run my report and effectively do a me.filter ........
I want to use this report multiple times to report Policies, Procedures etc.
Anyone got the magic answer?
Thanks
Jim