how do I apply a filter to a command button then open a report

P

Pedders

From A command button, I want to filter on a query and then open or preview a
report and print the results, i will have a few buttons on the same form
runing from the same query but runing a diffrent query and the same report.
 
D

Duane Hookom

You can create the command button using the wizard. Then modify the code to
look like:

Dim strWhere as String
strWhere = "[SomeField]= 'some value'"
DoCmd.OpenReport "rptSomeReport", , , strWhere
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Can I save a sql statement generated by a search form? 1
How to automate update on weekly reports spreadsheet 0
Getting Radio Buttons to work, that are inserted via AutoText 0
Request Form - Alert Team Member 0
filtering a form based on a filter on an open form 2
Print reports with creteria - 2 questions.. 1
How do I set focus (and select text) on a text box on a modeless userform? 0

Top