Limiting Queries on Form

L

LinhartK

I am working with a database for software check in/out. One of the tables
contains all of the software company information (tblCompany) and another
table contains information about specific software products (tblProduct)
including an index that points to tblCompany. In a form I am building
(frmCheck) I want to be able to select the company via a drop-down combo box
and for the product have a drop-down combo box that displays only products
made by the manufacturer in the previous combobox.
IE: If I select Adobe for the manufacturer field, I want the product field
to only display products made by Adobe.
I have posted on another forum and searched a bunch but I have come up with
nothing so far. Thanks for your time.
~Kira
 
K

Klatuu

Make the rowsource for the second combo a query filtered on the value in the
first combo. In the after update event of the first combo, requery the
second combo.
 
L

LinhartK

Could you possibly provide me code for that, or possibly an example? Thank
you so much for your time.
 
Top