Filter By Selection

[Arnie]

Morning all
can anyone tell me how to prevent a user from selecting a text box for
filtering by selection?

i have a filter by selection button that i only want the user to filter on
one specific field and not be able to filter on any other text box. I cant
find any reference to preventing other text boxes being searched on.

If .........site selected then

DoCmd.RunCommand acCmdFilterBySelection
Else
MsgBox ("You Can Not Filter on this Selection")
End If


Thanks in advance

 

[hunterpaw via AccessMonster.com]

Morning all
can anyone tell me how to prevent a user from selecting a text box for
filtering by selection?

i have a filter by selection button that i only want the user to filter on
one specific field and not be able to filter on any other text box. I cant
find any reference to preventing other text boxes being searched on.

If .........site selected then

DoCmd.RunCommand acCmdFilterBySelection
Else
MsgBox ("You Can Not Filter on this Selection")
End If

Thanks in advance

Hi Arnie,

The only way I know to do that is to disable the menu Filter commands, both
on the toolbar and the shortcut menu.. However there is no guarantee that
the user will not be able to restore those menu commands.

You can download Access MVP Bill Mosca''s Properties Setter to help prevent
the user from performing unwanted actions.
http://thatlldoit.com/utilsaddins.aspx

 

[JimBurke via AccessMonster.com]

I don't know that this will work, never done filtering in this way, but
there's a property called FilterLookup that can be set to Never. You might
want to try that.