Searchable Forms

[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

 

[Gavin Webb]

Thanks.

Ideally what I want is for users to be able to do it
without right clicking on things. The users will not be
computer friendly people, so I want to make everything as
simple as possible.

I have now added the line:

DoCmd.RunCommand acCmdFilterByForm

to the Load event of the Form, but they still have to
right click to 'execute the search'.

I've tried adding a command button to press to do this,
but it is disabled while the form is in filter mode and I
can't enable it...

any ideas?

Gavin