Filtering a Form

S

sweisbro999

I am working with a database that has approx 1300 records in it and i a
trying to set a a form that will allow a user to select certian criteri
and then search for what records meet the criteria. the user i
selecting the criteria from a series of list and combo boxes. the
after they have selected all their criteria another page pops up an
shows them all the records that meet their criteria. the records ar
displayed by their job # and not their record #
can anyone help me figure this out???
 
S

Steve Schapel

Sweisbro,

The form can be based on a Query. In the Criteria of the query, you can
refer to the controls on the first form, using syntax such as this...
[Forms]![NameOfFirstForm]![NameOfCombobox]

I guess you could have a Command Button on the first form, which will
open the second form. Another way to do it is just have the one form,
bound to the query, and the criteria selection comboboxes in the Form
Header. In this case, you can use the Requery method to update the
records displayed.
 
Top