468,284 Members | 1,489 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,284 developers. It's quick & easy.

Acc97 Advanced Filter - Capturing the Filter for report Filter

I have a form Form1 which when the Advanced Filter/Sort is used
creates a form(maybe) with a title 'Form1Filter1 : Filter'. When I
apply the filter to Form1 it is applied, but the value of Form1.Filter
is ''.

How do I obtain the Advanced Filter/Sort criteria as a string ?

I cannot reference the object 'Form1Filter1 : Filter' by using
Form1Filter1.

thanks in advance.
Nov 13 '05 #1
2 2186
In code use:

Me.filter
So if you wanted a report to display what you have filtered on a form, you
could use:
FilterOn = True
Me.filter = forms!formname.form.filter

HTH
Paul
"Mike Sweetman" <ac******@sweetman.force9.co.uk> wrote in message
news:48**************************@posting.google.c om...
I have a form Form1 which when the Advanced Filter/Sort is used
creates a form(maybe) with a title 'Form1Filter1 : Filter'. When I
apply the filter to Form1 it is applied, but the value of Form1.Filter
is ''.

How do I obtain the Advanced Filter/Sort criteria as a string ?

I cannot reference the object 'Form1Filter1 : Filter' by using
Form1Filter1.

thanks in advance.

Nov 13 '05 #2
Thanks Paul

Moments after the post (I was at my wits end) I realised that the
problem was that my 'filter' was actually only setting the value of
me.orderby because that was what I was doing - using the advanced
filter/sort to reorder my data. Hence the me.filter was '' because I
had not set any criteria in this aspect of the advanced filter.

"Paul" <pz****@rogers.com> wrote in message news:<j9********************@rogers.com>...
In code use:

Me.filter
So if you wanted a report to display what you have filtered on a form, you
could use:
FilterOn = True
Me.filter = forms!formname.form.filter

HTH
Paul
"Mike Sweetman" <ac******@sweetman.force9.co.uk> wrote in message
news:48**************************@posting.google.c om...
I have a form Form1 which when the Advanced Filter/Sort is used
creates a form(maybe) with a title 'Form1Filter1 : Filter'. When I
apply the filter to Form1 it is applied, but the value of Form1.Filter
is ''.

How do I obtain the Advanced Filter/Sort criteria as a string ?

I cannot reference the object 'Form1Filter1 : Filter' by using
Form1Filter1.

thanks in advance.

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by CSDunn | last post: by
8 posts views Thread by dick | last post: by
1 post views Thread by lorirobn | last post: by
reply views Thread by Andrew Meador - ASCPA, MCSE, MCP+I, Network+, A+ | last post: by
reply views Thread by Andrew Meador - ASCPA, MCSE, MCP+I, Network+, A+ | last post: by
reply views Thread by NPC403 | last post: by
2 posts views Thread by MrBee | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.