Listbox in a report bound to a query that uses a different query

[JamesWB]

Hi, I have a report called JobPlans which loads from a query. That query contains a column JobID from a table about jobs. (JobDetails)

Inside that report I want to display a list box, with its rowsource as a different query. I'm trying to display items linked to jobs. There's a join table for that which links the JobDetails and ItemDetails tables, Jobs_Items.

Inside Jobs_Items, there's a JobID, so I assumed that to populate the list box with related items, I could use the criteria [Reports]![JobPlans]![JobID] on the JobID field in Jobs_Items.

This does not work. The report appears not to know what that JobID is.

Any pointers as to where I might be going wrong please? The report loads fine from the bound query which grabs columns from the JobDetails table. However, the list box should be simple but apparently is not.

Perplexed.

 

[Mihail]

As far as I know, you can't.
A report is... a report; a paper sheet that display something. Or in a paper you can't have a listbox in order to change the contain of that paper.
So, you must prepare all the variable items in a form then, when you run the report, the query which drive this report will read this items and react as necessary.