Getting dates from query parameters onto a report

[Mattbro]

Hi all,
Sorry if this sounds complicated;
I have a table -FinalSheet2, containing data including [Received Date].
I have A report 'RpAudit' which is populated by a query 'AuditStats'.
The datasource for 'AuditStats' is from a primary query 'QryAudit'.
The datasource for the query 'QryAudit' is table -FinalSheet2
I have a form 'FmAudit' which contains two textboxes-Start and End. The user enters the dates they wish to audit, and using the 'on.update event, the dates are used to generate the report 'RpAudit'. The dates manifest in the query 'QryAudit' by the criteria; 'Between [Forms]![Audit]![Start] And [Forms]![Audit]![End]' on the [Received Date] field.
Upon update of the the End textbox, the 'FmAudit' Form closes, and the report appears. Lovely.

What I want is to put two textboxes -TbStart and TbEnd on the RpAudit report that display the dates entered in the Start and End textboxes on the form FmAudit so the reader will know the dates audited. I have tried binding the Control Sources of TbStart and TbEnd to the Start and End textboxes on the 'FmAudit using the Expression Builder, but am just getting '?Name' appearing. Any ideas gratefully appreciated.
Regards,
Mattbro

[JoeM]

Typically, what I do in this case is create a single record table that I use to store the values of my Form selection, so all the criteria I enter is bound to a single record table.
Then, I include that table in my query that the Report is based on. Since it is a single record table, you don't even need to create a relationship between that table and the other tables in the query (the Cartestian product between a single record table and and other tables/queries keeps the same number of records). Then, those criteria fields are available for you to place on your report.

[Mattbro]

Ah-cracked it. The way to do it was to bind the textboxes on the report to the textboxes on the form, but to remove the DoCmd 'close' command and replace it with me.visible=false. Thus the form remains open and the data appears. I liked your idea, JoeM, but had trouble binding the control souce-still got the '?name' caption!

[JoeM]

I liked your idea, JoeM, but had trouble binding the control souce-still got the '?name' caption!

One sure-fire way to avoid that is to start from scratch, creating a new Form with the table as your Control Source, and then add fields directly from the Field box (drag and drop). Then you are certain to get all the sources set properly.