Hi, Rob.

Try adding the "Filter By Form" command from the "Records" category to your
custom CommandBar. Just drag and drop the "Filter By Form" icon onto your
custom CommandBar.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)


"Rob Parker" wrote in message
...
I posted this in the
microsoft.public.access.commandbarsui group yesterday,
but there's been no response so far, so I'll try here.

The Datasheet View Cell menu (I'm using Access 2000) has
a "Filter For" command - it has a text box beside it
into which you can enter criteria eg. "a or b". I want
to create a custom right-click menu for a form with this
command as one of the options, but it doesn't appear in
the list of commands available when I try to customize my
menu. All the other Filter ... commands are available in
the Records category, but not the one I want. I can't
find it in any other category either. Where is it, and
how can I add it to my custom menu?

TIA,

Rob