Custom report title based on dialog box options

[Gastrifitis]

I have to generate reports based on an 8 week cycle for 4 different routes. I can get a dialog box, which gets the info using radio buttons, to pass this info to a query, and base a report on the query. But I need the report title to reflect the choices made in the dialog box. For example, if rte 3 and week 7 were chosen, I want the report title to say Route 3 Week 7. And so forth. What do I need to put in the report title to do this?

 

[SydneyGeek]

Let's say the dialog is frmOptions, with optRoute and optWeek as the relevant controls.

The report title needs to be an unbound TextBox, with an expression referring to those controls: ="Deliveries for Route " & [Forms]![frmOptions]![optRoute] & " during week No. " & [Forms]![frmOptions]![optWeek]

Make sure that the form is not closed before opening the report, or you will get error messages. Also, change names to suit.

Denis

 

[Gastrifitis]

Thanks! I was having trouble with the syntax, and I wouldn't have guessed anyway that the dialog box needed to stay open while that was going on. This should work great.