Form search

[Lifeseeker]

Hi

I have a main form set up and on the form there are multiple fields.

Users would like to search in one of the fields on the main form without having to go to the report.

The search is using the contain() function to look for a string found in the field.

Is it possible to have a small search form set up so that users can choose what field on the main form to look in? They will then click on a search button to filter the record on the main form?

Thoughts comments much appreciated.

 

[John Big Booty]

Perhaps the sample posted here is the sort of thing you are after, or will give you some ideas.