Filtering a Continuous Form

  • Thread starter Thread starter Andy Levy
  • Start date Start date
A

Andy Levy

Hi

I have a Continuous Form, have also placed a text box in the page head.

If the user enters a word into the text box i would like the form results to
be filtered by any record containing that text, no matter what field it may
appear in.

I can half do this with the filter method, however i cannot get the filter
to search every field. I have a lot of fields on the page.

Is there a way of filtering that shows up a record no matter which field the
Desired Text appears in?


Thanks


Andy
 
Andy,

I don't believe there is an easy way to do that.

It would be possible to use a query that concatenated all the text fields
together and use a Like operator with that. This would require a great deal
of processing and the results could be very slow in coming.

eg.

SELECT * FROM Table WHERE TextField1 & "~" & TextField2 & "~" & .... &
TextFieldN LIKE "*String To Find*"

The ~ between each field is to prevent accidental matches if two
concatenated fields combine to form the String To Find.

Rod Scoullar
 
Back
Top