1 table and 2 Listboxes: How do I make the second one depedant?

[swk209]

I am using a single table.

I have two seperate forms, the first of which asks for steel pole height and
the second asks for minimum break angle. The steel pole height has many
options, i.e. 76, 80, 100, etc, as does the min break angle (0, 1, 20, etc);
However, there are only a certain combination of steel pole heights and min
break angles that will yield results in the report.

I wish to make the min break angle List box dependant upon what the user
selects in the List box for steel pole height, displaying only the min break
angles that will yield a result. How do I do this?

I have already tried to gather the List box information for the min break
angle from the Query for the steel pole height & min break angle, but the
list box appears blank regardless.

Thanks.

 

[Arvin Meyer [MVP]]

Here's an example of exactly what you want to do:

http://www.accessmvp.com/Arvin/Combo.zip