Filters not working in Access 2003/2007 as in Access 2000

In Access 2007 when I right click on a field that is a checkbox, I get the options "Is Selected" and "Is Not Selected" (among the other options listed).  Although this is not an exact match to "Filter by Selection" and "Filter Excluding Selection"  for a field that is either True or False the options are fairly similar.  I presume that you do not see these options displayed when you right click?

There are certainly there in A2003 - I guarantee you that.  I have dozens of apps that use these ... as well as many custom menus and toolbars, etc with those options.  In fact, they are about the most popular right click options.  Don't know about A2007.  If they are gone or renamed .... shame on M$ !!

mx

I do have the "Filter by Selection" or "Filter Excluding Selection" menu items but when I use them I get the following error:

The command or action '' isn't available now.
 * The type of object the action applies to isn't currently selected or isn't in the active view.
 Use only those commands and macro actions that are currently available for this database.


I am missing right click one menu item something like:
  Filter for ______________  (type in what you are looking for like Bob*)
After 10 years of trying, I finally taught most of my users to use this command and now it's gone!!!

Not seeing Text Filters in the menu when trying to filter a form.  Is there anyway to add items to the right click menu?  Maybe I'll open a separate question for that.

Hmm...go into the design view of the form and look at its Properties.  On the Data tab, is the Allow Filter set to No?  If so, set to Yes, save the form, view it in Form mode and see if the filter options appear.

I played around with it a little more and it seems to work as follows:

 "Filter by Selection" or "Filter Excluding Selection" work on text fields but not checkboxes (like they did in Access 2000)

"Is Selected" and "Is not Selected" appear (and work) for subform checkboxes but not for main form checkboxes.  I would be happy if I could get them to appear for forms also.

Checkboxes in 2007 will not have any filter options other than "Is Selected" and "Is not Selected" (i.e. you will not get the same filter options as you do for a text field).
You stated:
"Is Selected" and "Is not Selected" appear (and work) for subform checkboxes but not for main form checkboxes.
Okay, well if you are on a form that you can see the filter options for the text fields (similar to the above image) then any checkbox control on the same form will have the "Is Selected" and "Is not Selected" filter options appear as well (provided that those controls are bound to a field).  So, check your main form to ensure filters are allowed.  If they are then you will have all the filter options for each type of control on the form.

Filters are allowed on this form.  It looks like Access 2007 had a different right mouse menu for subforms then on forms.  For example, it has a specific subform category that appears on the subform menu but does not appear for form menu.  Attached are snapshots of both menus.
temp.doc

Well that is odd since I get the same right-click menu (i.e. the one you showed for the subform) on both the form and subfrom in my application here.  Are you sure that you don't have a custom Shortcut Menu Bar created/assigned to the form object (Form properties | Other tab | Shortcut Menu Bar }?

Nope, no shortcut Menu Bar.

Hmmm...well then, you've got me stumped...can't replicate the issue on my end.  Is it possible for you to post a stripped down/sanitized copy of the database (i.e. a database with just the form and subform in it along with any related queries and tables [with all data deleted]) to see if a solution can be derived from that copy?

Thanks for you help.  I had to import all my objects into a clean database.  Now the menus are working correctly.  Access 2007 has now got a smart shortcut menu bar based on the data type.  Apparently when I converted from 2000 to 2003 something didn't work right.