When I use DoCmd.RunCommand acCmdFilterByForm, all command buttons on the form are dimmed. This appears to be by design. I do not want the user to open the database with any Access menus or toolbars, only the programmed command buttons on the form. I have created created a custom Query by Form popup form with unbound fields, but I lose the AND/OR tab options of the built-in Filter by Form. So my questions are two-fold:
1. Is there a way to use the Filter by Form feature on a form where the Access window frame, toolbars and menus are hidden? or
2. How do I allow for multiple criteria in the query for a single field (i.e. California OR New York in the State field) in the custom QBF?
1. Is there a way to use the Filter by Form feature on a form where the Access window frame, toolbars and menus are hidden? or
2. How do I allow for multiple criteria in the query for a single field (i.e. California OR New York in the State field) in the custom QBF?
