Interestingly, Access allows you to use a Subform/Subreport Control in a
Report which has a Form embedded (so you can display a Form in a Report) but
does not allow a Subform/Subreport Control in a Form which has a Report
embedded (so you cannot display a Report in a Form).
You could put a Command Button on the Form to Open the Report, and, if
necessary, collect the Criteria from that same Form.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.