Can't filter subform (in datasheet view)

[tsison7]

I have a subform in datasheet view and if I open the database while holding
down shift to bypass the restrictions I'm able to do what I want with that
subform in regards to flitering.

But once I put it on the server for others to access, the ability to filter
that subform goes away. I limit their access via the startup and I don't
want them changing data in the subform. Is there a setting that will allow
me to protect the data while allowing them to filter? Do we control this
access through the main form or the actual subform itself?

Thanks,

 

[Jeanette Cunningham]

Are you using a built-in popup menu to filter? Do your startup settings
disable the default popup menus? If that is the case, you could build your
own custom popup menu that would filter the subform. I am sure if you search
this discusssion group's old posts you would find references to how to
create your custome menus.

Jeanette Cunningham

 

[tsison7]

The way I want to filter it is just by right clicking within the datasheet
and choosing filter by selection.

This works fine when I startup using the "shift" to bypass my startup
settings. But if a user startsup normally, this function seems to be
disabled. Right clicking does nothing.

 

[Jeanette Cunningham]

Yes,
if you are hiding the database window and all the other interface from the
users this is what happens.
You must build your own pop up menu that has the filter command on it and
set it as the popup menu for that particular datasheet.
If you go Tools >> Startup and look for the checkboxes for Allow full menus,
Allow default shortcut menus, Allow built-in toolbars and Allow Toolbar/Menu
Changes - they will have been unchecked. You do this to lock up the Access
interface from user.

Jeanette Cunningham