Filter

[Nathan]

I am creanting a Computer Hardware/software library
database i was womdering if i could set a filter for the
Type of item combo box Hardware/software to have it only
bring up the items that are labled as such. Also to have
a second filtered combo box for the category under the
previous filter eg. under hardware - vga or metwork or
under software - OS or game..

Thanks

Nathan

 

[Larry Linson]

Take a look at http://www.mvps.org/access/forms/frm0028.htm which may help.
As a start, you might "work backward" -- use the Wizard to create the second
Combo Box (as designated in the article) to populate the Form -- that is one
of the Wizard's options. Then, based on the reference article, modify it so
that the second Combo Box (generated by the Wizard) uses a Query that limits
its contents by the first Combo Box.

Larry Linson
Microsoft Access MVP