By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,543 Members | 2,169 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,543 IT Pros & Developers. It's quick & easy.

FIlter icons and functionality into forms

P: n/a
Hi all. Trying to move Filter By Selection, Filter By Form, and
Apply/Remove Filter directly into my form. No luck. Is there anyway
to move them into the header of the form or, as another option, is the
code needed to write out a filter worth pursuing?

jg
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
You can move into Filter By Form with:
RunCommand acCmdFilterByForm

However, in Filter By Form you cannot click the buttons, so there is no way
to place a command button on the form that moves back to Form view again.
The Toolbar buttons do the job fine.

If you want to get the filter string that resulted from a Filter By Form,
just examine:
Me.Filter
assuming that Me.FilterOn = true.

Filter By Form does not work in an MDE or runtime, so it's not very useful
if you do serious work in Access intended for others to use.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"jeffgeorge" <ki*******@aol.com> wrote in message
news:4f**************************@posting.google.c om...
Hi all. Trying to move Filter By Selection, Filter By Form, and
Apply/Remove Filter directly into my form. No luck. Is there anyway
to move them into the header of the form or, as another option, is the
code needed to write out a filter worth pursuing?

jg

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.