Displaying Data In A Subform.

I have a form that displays a specific set of data depending what you select in a group of list boxes before. See image below:

13516

You select a PIPELINE, a YEAR and then a HAZARD, and this brings up a series of risk assessments depending on what you've selected. The RISK ASSESSMENT is actually a subform thats been set up to look like a list box. (Side Note: The reason I have done this rather than just use a normal list box for the risk assessment is I wanted to have a combo box attached to each record in the list box. Access does not allow you to do that so I had to fudge it). The RISK ASSESSMENT subform is populated by a query. At the bottom of the form is a normal list box displaying the same information thats in the RISK ASSESSMENT - I have done this as a test to ensure that my fudged subform is doing it's job.

From the fist screen capture you can see that the combination of PIPELINE, YEAR and HAZARD produces 3 risk assessments - this is also confirmed in my test list box. Everything is ok so far.

The problem I have is that I can only get my subform to display the data when the PIPELINE selected in the first screen capture is selected. Any other pipeline selection does not display the data in RISK ASSESSMENT. However, I know the data is there as my test list box displays the data. See image below:

13517


Therefore, my question is, why would data be displayed in the subform for some selections but not others, even though the data is there?

Any help would be greatly appreciated,

Best Regards,

Aaron