Limiting Queries on Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Could you possibly provide me code for that, or possibly an example? Thank
you so much for your time.
 
Back
Top