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