using the selection from a combo box elsewhere in a form

[tonyaims]

I have materials that can be put into a PO grouped into
classe - doors; windows; sealants; etc. In a PO form, I
want the user to select a material group from a combo box
and use that selection in a 2d combo box to list all of
the materials in the selected group.
I used a wizard in the first combo box and selected:
"Remember the value for later use"

But I cannot figure out how to specify to Access to use
that value in the query that access builds to get the
values for the second combo box.

Can anyone help?

 

[Bill]

cboMaterialClass , cboMaterialSelect (assumed names)
open the property sheet for the 2nd (cboMaterialSelect) combobox.
now the row source type on the data tab should be table/query.
the Row Source will be a query like this:
"SELECT Material FROM tblMaterials WHERE MaterialClass =" & cboMaterialClass
tblMaterials is the table name where information is stored
Material is the field storing the information you want to select (wood) from
the dropdown of the combo box.
MaterialClass is the field where Door, etc. is stored
Note: Use the Quotes and & operator exactly as shown
HTH