Filtering

[Guest]

I have a tables with loads of records in it. What I want to do is be able to
filter this in a form using a combo box. Firstly I want to have a combo box
that will filter on either IT or Business depending on what is selected by
the user. Any ideas?

 

[Guest]

Create a main form, and a sub form with a data sheet view that list all the
records in the table.
create the combo box in the main form, not bounded that list It or Business.
The record source of the sub form will look like that
Select * From MyTale Where MyField like
(nz(Forms![MainFormName].[ComboName],"*")
If no record is chosen in the combo everything will be displayed