[AccessD] Sub report filter

Charlotte Foust charlotte.foust at gmail.com
Tue Jan 13 13:44:33 CST 2015


"Type" is a keyword in Access and VBA.  It's not a good field name.  Label
it whatever you like on the form or report, but change the field name!

Charlotte

On Tue, Jan 13, 2015 at 11:14 AM, Gordon Stubbs <gordons2 at pacbell.net>
wrote:

> Hello everyone,
>
> It's been quite a while since I have asked a question of the group.
> I have a report with a sub-report with a field "Type".
> I also have a form with a field "filter-Info".
> I would like to filter the sub-report field "Type" based on the field
> "filter-Info".
> How do I get the sub report to do that.
> I've tried may ideas and haven't got it to work.
>
> If I modify the query type field criteria to match the "filter-Info" info
> it will filter correctly.
> How can I modify the query criteria using VBA?
>
>
> Thank you.
>
> Gordon
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


More information about the AccessD mailing list