Print command

  • Thread starter Thread starter Bob Hughes
  • Start date Start date
B

Bob Hughes

Using Office 2K & windows 2K
I have a form that displays information in a table. A command button
executes the command
DoCmd.OpenReport "RptTable", acPreview, , Form.Filter

If I right click on the form and click on "Filter by Selection" the form
displays filtered information, after clicking the print button the report
displays the same information.

After closing report If I then right click on the form and click on "Remove
Filter/Sort" the form displays all information, but the report still
displays the filtered information.

Can someone please tell me how I get the report to show what the form does?

Bob
 
I can't duplicate your problem, but do know that Access has a bug/feature of
"persistent" filters in forms and reports. Reports usually have a query as
their data source. If you were to create a query with your form selections
as the criteria, the report would accurately show the selected records.
-Ed
 
Allowing users to right click & set filters is easy & requires no extra
coding. When I look at the filter contents after any right click change
form.filter contains all the changes. When I right-click on remove
filter/sort form.filter still contains the origional filter but the form is
displaying all?? Also the OrderBy is not cleared.

I may just have to add a clear button & clear the filter myself. But that's
not tidy

Bob
 
Back
Top