search function

  • Thread starter Thread starter Jason
  • Start date Start date
J

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?
 
Should i use an unbound textbox where people can type in what they looking
for
Click to expand...
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.
Click to expand...
No - use the subform's filter property.
 
Back
Top