Need to create form filters for users using access runtime (1 Viewer)

We have a form which I need to add filters on for users who use access runtime.

Normally in access I'd just right click on the field and choose "Filter By Selection" but this option is not available when accessing the database using access runtime.

I have no coding knowledge btw

Is there a simple way of making a filter button beside a field that would enable the user to filter including (or excluding) the contents of that field?

Many thanks

Paul

Hi,

You can make a new menu item and assign it to the control you want them to use it on:

Right click on the tool bar somewhere
Select cutomize...
On the Toolbar tab click New...
Type in a name for your menu, 'MyMenu' is as good as anything while you test this
Click ok then you will see your menu floating about
Goto Commands and select Records form the list
Then find Filter by Selection and drag and drop it to your menu bar
Now go back to commands
Select MyMenu from the list and click Properties
Change Type to Pop-up

Close that all down

Open your form in design mode
Select the control(s) you want to use the menu on
open the properties
Goto the Other Tab>Shortcut Menu Bar
Select MyMenu from the list (there wil be only 1 there)

Hopefully that will get you going.

Any questions ask.

Cheers,
Goto

Nice one Ian!

Works perfectly & I've coloured the filterable fields so that the users can see which ones they can filter on.

Many thanks

Paul