Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Creating a report based on form filter
- Thread starter benrob82
- Start date
TSIsolutions
MIS
Hi benrob82
How are you filtering the form? You may have to elaborate a little more. But if you are programatically using Filters like:
strFilter = "Country = 'USA'"
Me.filter = strFilter
Me.Filter = true
Also, if you are generating a report from the Form by clicking a button, then you could always do the following:
DoCmd.OpenReport "ReportName" , acViewNormal, , strFilter
Where the strFilter is placed in the WhereCondition of you OpenReport Command.
Hope this helps,
Let me know
How are you filtering the form? You may have to elaborate a little more. But if you are programatically using Filters like:
strFilter = "Country = 'USA'"
Me.filter = strFilter
Me.Filter = true
Also, if you are generating a report from the Form by clicking a button, then you could always do the following:
DoCmd.OpenReport "ReportName" , acViewNormal, , strFilter
Where the strFilter is placed in the WhereCondition of you OpenReport Command.
Hope this helps,
Let me know
- Status
Similar threads
- Locked
- Question
