Report produced from a drop down box and query

[antr]

Hello,
Apologies, once again I have tried searching here with no luck. This is for access 2010 web data base

I want to be able to select a project from a drop down combo box, and when selected a report to be run. However, what I want to display in this combo box is from a query - how can I do this as im stuggling

The query basically produces a list of all projects which are "boarded"

Thanks

 

[CJ_London]

put the following as the rowsource to your combobox

"SELECT ProjectName From YourQry ORDER By ProjectName"

Substitute your field and query names as required