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!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Filtered Reports

Status
Not open for further replies.
GLENEE

GLENEE

Programmer
Feb 9, 2005
64
0
0
GB
I have a form that displays all the records from a table. On this form i have a button that runs a report displaying the same records. What i want to do is apply a filter to the form and then run the report displaying only the filtered records from the form.Is this possible? I assume i have to put something in the following line to filter but i'm not sure of the syntax: DoCmd.OpenReport "rptCaseSummary", acPreview, "", ""
Any advice would be appreciated. Thanks
 
Sort by date Sort by votes
ok, solved it, just added Me.Filter into the criterion.
 
Upvote 0 Downvote
NB: Remember to reset the filter - Me.Filter = "" after the report has run
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Teri Bridges
  • Locked
  • Question
Reports Combobox-List box
Replies
1
Views
82
dhookom
dhookom
breezett93
  • Locked
  • Question
What should be multiple reports is becoming one report with multiple pages 1
Replies
13
Views
97
dhookom
dhookom
PaulP1
  • Locked
  • Question
Microsoft Access Reports
Replies
2
Views
54
razchip
razchip
NeilT123
  • Locked
  • Question
Compress PDF reports
Replies
0
Views
28
NeilT123
NeilT123
egstatus
  • Locked
  • Question
How to tell if a report uses sub reports? 1
Replies
3
Views
32
egstatus
egstatus

Part and Inventory Search

Sponsor

Back
Top