Printing from a split-view form datasheet section

[kristianlee03]

Hi all,


I have a database in Access 2007, in which there is a split view form (which doesn't actually allow any data entry directly) with a datasheet below.

I have a macro which can filter the view of this form (similar to the way in which the Access 2007 'Asset database' sample does it), however I have no way of outputting the data shown to an xls or printer when the filter has been applied.

Is there a way of doing this? I have experimented with building Reports for this purpose with limited success.


Regards,

Kristian

 

[Mr. B]

kristianlee03,

A report is the way to go. From your description you will need a report based on the same record source as your form. Then you will also need a subreport based on the same record source as your current sub form.

You can link a sub report to a main report the same way you link a sub form to a main form.

HTH

 

[kristianlee03]

Surely though, the report will not be based on the filter I've run on the form, but instead based on the full set of values in the table?

 

[Mr. B]

That all depends on what you want. If you truly want to have the report print exactly what you have on your form and that data is filtered, then you would use the same record source, including any filtering, to get the same results.

If you want all records then you would not want the filtering.