 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Modules / DAO / VBA / March 2007Putting records filtered on a form into a report.
I have some forms were the users are able to use a filter-by-selection,sort either by AZ-ZA. The users then want to see the results in the report exactly as they are on the form after the filtering and sorting is done. Any idea on how to accomplish this? TIA -Craig The form filter can be passed to the Report as in the following code... DoCmd.OpenReport "Report1", acViewNormal, , Form_Form1.Filter Regards, Matt > I have some forms were the users are able to use a filter-by-selection,sort > either by AZ-ZA. The users then want to see the results in the report exactly [quoted text clipped - 3 lines] > TIA > -Craig |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.