Using filtered form data as record source for report


K

Ken Warthen

I have a split form in an Access 2007 database where the data grid shows the
records from a query. The user can filter any combination of fields from the
the drop down headers. I have a command button above the data grid that
opens a report with the same query as its record source. I'm trying to
figure out how to pass the filtered data to the report so it will show only
those records that the user is seeing in the data grid of the split form.
Any help with this issue will be greatly appreciated.

Ken
 
Ad

Advertisements

A

Allen Browne

You may be able to pass the Filter of your form as the WhereCondition of the
report.

The code for your button would look like this:
Dim strWhere As String
If Me.Dirty Then Me.Dirty = False
If Me.FilterOn Then strWhere = Me.Filter
DoCmd.OpenReport "Report1", acViewPreview, , strWhere

It may be a bit more complex if you have combo boxes where the bound column
is not the display column, or multi-valued fields.
 
K

Ken Warthen

Allen,

Thanks so much for the help, your suggestion seems to work perfectly. I
have a multi-valued field displayed on the split form and your code seems to
be able to pass any filtering of that field to the report without issue.

Thanks again,

Ken
 
Ad

Advertisements

Joined
Sep 10, 2015
Messages
1
Reaction score
0
Allen: Thank you for your answer. You mentioned that "It may be a bit more complex if you have combo boxes where the bound column is not the display column". I have the exact situation in Access 2007, in such a situation, the following code will not work:
If Me.FilterOn Then strWhere = Me.Filter
DoCmd.OpenReport "Report1", acViewPreview, , strWhere
Could you explain how to handle this situation?
Thanks.
 

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

Report Record Source 1
Report - Record Source 5
Report Record Source 1
Report Record Source 2
Report Record Source 1
Report Record Source 2
Report with no record source 1
report record source 3

Top