Passing parameter to calculate Report title

[aviv]

I'm new to access, but I'm reading alot and trying things out.

I have a class roster report based on a query that lists the students enrolled in a particular class. I pass the class code to the query via a parameter to establish which roster. For example, when prompted I enter “12wehd” to get the list of students in that class.

I have another query that returns course description fields from different tables that I’d like to use as the title of the above report. For example, class code field + session + Location + instructor, etc. to make up the title. I pass the same parameter to the second query as I do to the first to return those fields.

How do I put the resulting fields together to create the different titles for each class roster? I’ve tried building an expression for a test box in the Report Header, but I keep getting error messages.

Also, is there a way to pass the same parameter to both queries once when I run the report, without having to respond to two parameter inputs?
Thanks in advance for any suggestions.

[June7]

Query input parameter prompts are bad. Can't control validation and unless the prompt results in a new field of data (same value on each row) it cannot be referred to anywhere else.

The report record source might need to be a query with table/query joins. Would have to know more about your data structure. Copy project, remove confidential data, run Compact & Repair, zip if large, attach to post. 2mb zip allowed. Attachment Manager is below the Advanced post editor.

Use a form to input criteria in unbound data control (textbox, combobox, listbox). Query refers to the control as the input parameter, as long as the form remains open when query/form/report opened.