Making a form searchable

[Gavin Webb]

Hi,

I have a form with a subform, linked to tables.
At the moment, I can only scroll through records in the
tables by using the standard record navigation bar at the
bottom of the form.

How can I add the feature of being able to type search
criteria into the fields on the form and select records
that way?

Thanks
Gavin

 

[Kevin @ 3NF]

Look into filter by form button at the top of the window...pretty useful
functionality

 

[Gavin Webb]

Thanks. That is useful.

Is there any way of getting the functionality of that
button into a button on the form?

It's just that I wanted to discourage users from clicking
buttons on the toolbar, I was going to disable as much as
possible. They are not super users, some of them have
only just figured out what the mouse is for...

Gavin

 

[Kevin @ 3NF]

Yes,

DoCmd.RunCommand acCmdFilterByForm

Put that in the onClick event of your button

 

[Gavin Webb]

That works beautifully...
however, you still have to right click to get the option
to 'execute' the search.

I've added a button to do this, but it is automatically
disabled when the form is in 'filter mode'.



G