Print out the data sheet portion of a split form

[Dpot]

I have a form that is split so that the data sheet view is at the bottom. I don't want to change the print property on the forms properties tab, I'd like to leave it on "Form only" because the form is printed 99% of the time. I'd like to add a button to print out the data sheet, so it's available as an option if needed. Any idea's on how I'd set the focus to the data sheet to print?

[Seth Schrock]

It would probably be easiest to create a report that looks the way that you want it to with all the appropriate filters and then print that.

[Dpot]

The filters will change though depending on what information the user wants. So I can't make a report with predefined filters.

[Seth Schrock]

You don't have to have predefined filters. You can pass the filters to the report when you open it to print it.

[zmbd]

Seth is correct.
Filters can be created and passed on the fly.

Forms are not normally printed; however, if you insist then one can add a command button to the header in design view and use a VBA script to toggle the form print state from printing the grid to printing the form. The caption of the command button can be changed to indicate status... for that fact, the colour can be changed too. The button can be set to be visible only on screen and not when printed.

Z