Populate a list box from one of three choices

[Suzanne]

I have a table of >4,000 line items (hazards); each hazard has a unique
hazard id; each table includes the hazard id.

Problems/Questions -- How do I:
List unique values in the combo box (so I don't have hundreds of repeating
values); and
Populate the list box with combo box selection

I need to populate a list box (containing CAS Code and Hazard Name) based on
one the following drop down (combo) selections:

CAS Code: Almost all hazards have a unique code -- some don't have a code
at all and some share a code

Exposure Route: there are 4 exposure routes; up to all four routes may be
associated with the hazard (or none)

Target Organ: there are 30 or so entries; there may be 10 or more hazards
associated with a target organ (or none)

Synonyms: There are 1,000 synonyms; each hazard may have several synonyms
attached to it (or none)

Users need to select a CAS Code and populate the list box with associated
hazard(s); or select an exposure route...; or select a target organ...; or
select a synonym...

Thanks -- SuzLeigh

 

[mscertified]

I have a table of >4,000 line items (hazards); each hazard has a unique
hazard id; each table includes the hazard id.

Problems/Questions -- How do I:
List unique values in the combo box (so I don't have hundreds of repeating
values); and
Populate the list box with combo box selection

Use a query that does SELECT DISTINCT - look in Access Help
I dont understand the rest of the questions but its best to ask one question
at a time if you want to get an answer..

 

[Suzanne]

Ok...

I have a combo box (Exposure Route) row source value list (Ingestion,
Inhalation, Skin, Eye) which matches one or more 4,000 "hazard" line entries
(a hazard may be associated with none, one, more than one, or all four of
these values)

Once one of the four values is selected, the list box should contain only
the CAS Code and Hazard Name associated with the specified value (i.e., all
hazards associated with Ingestion); users must then select the correct data
from the list box

Most important: How do I populate my list box with the CAS Code and Hazard
Name based on selection from the Value List combo box which should then push
the correct data to the data entry table (tbl IHS Data)

REALLY nice to have: Is it possible to populate the list box from multiple
combo box selections -- i.e., filter by Exposure Route and/or Target Organ
and/or CAS Code and/or Synonym?

"Hazard ID" (in tblHazard) is the primary key field -- I have established
(via Relationships) a one-to-many relationship with tblHazard (also contains
CAS), tblExposureRoute, tblTargetOrgan, and tblSynonym -- all of which
contain Hazard ID

I have been pouring over examples here and on-line, but can't get them to
work. This is hugely frustrating. Would appreciate help from anyone...
please...

SuzLeigh