search function

[Jason]

Hi,

I was wondering, what is the best way to create a form with a subform to
search for records.

Should i use an unbound textbox where people can type in what they looking
for and reference that textbox in the subform's datasource like an query.

Can someone help me on this?

 

[Paul]

Should i use an unbound textbox where people can type in what they looking
for

That is my preferred option. Personally I like to have an unbound text box
for each field shown in the subform, then the user can search by multiple
criteria. If perfomance allows I update the filter on the OnChange event of
the textboxes so the subform narrows down to the matching records while the
user types - this creates a nice feedback mechanism (saves the user from
typing a whole bunch of criteria and hitting 'Search' only to discover no
records are returned).

and reference that textbox in the subform's datasource like an query.

No - use the subform's filter property.