Search Box

[syedadnan]

I am looking to have a search box in a form and through a command button when pressed it to displayed record what written in text box i want this text box to see all form fields and show matching results from all fields

 

[Isskint]

Hi

Use a query as the RecordSource for the form that uses the search
control as its criteria for each of the fields. If you want
to only find exact matches, the criteria would be of this
form:

Forms![name of form].[name of control]

The important thing is to put the criteria on different Criteria rows so
that matching any field is sufficient.

OR
Use a query as the RecordSource for the form and add an extra field that concatenates all the other (relevant) fields, setting that as the criteria.

 

[syedadnan]

Hi

Use a query as the RecordSource for the form that uses the search
control as its criteria for each of the fields. If you want
to only find exact matches, the criteria would be of this
form:

Forms![name of form].[name of control]

The important thing is to put the criteria on different Criteria rows so
that matching any field is sufficient.

OR
Use a query as the RecordSource for the form and add an extra field that concatenates all the other (relevant) fields, setting that as the criteria.

Thanks .. Will try and let your know