Making a form searchable

  • Thread starter Thread starter Gavin Webb
  • Start date Start date
G

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
 
Look into filter by form button at the top of the window...pretty useful
functionality
 
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
 
Yes,

DoCmd.RunCommand acCmdFilterByForm

Put that in the onClick event of your button
 
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
 
Back
Top