Multiple combo boxes in subform

[chadmichaelfoster]

Hi..A little background. I have taken a MIS course this semester and
leared quite a bit about Access compared to what I knew before the
class (nothing)...I am working on a Db for work now and have a
question. I have a table called tblPriceGuide. The fields are
Category, Brand, Model, Shaft, SteelPrice, GraphitePrice .

I have a form w/ subform that I want to pull data from tblPriceGuide.
Right now I have all of the fields...Ideally I would be able to have
multiple combo boxes...

A category combo box that would populate the brand combo box, then when
a brand is chosen it would populate a model combo box. This woudl
allow me to choose my model then I would choose shaft and it would
populate either the SteelPrice text box or the GraphtitePrice text box
depending on my choice. Where do I start? Thank you in advance for any
help.

 

[Al Campagna]

Chad,
Let me use cboCarMake and cboCarModel as an example. Select Chevrolet in combo 1, and
only Chevrolet models show up as a choice in combo 2.
In the query behind cboCarModel, use the value from cboCarMake to filter the CarMake
field in combo2.
cboCarModel
CarMake
=Forms!frmYourMain!frmYourSubForm.Form!cboCarMake

On the AfterUpdate event of cboCarMake, do a cboCarModel.Requery to ensure that the
combos are always in synch.