Fields on Report (from a data entry form) not showing when printing

[Varda]

MS Access 2010
Intermediate Level (not a beginner and not an expert)


I have a report that is filtered after entering dates in a form. When I preview the report, it shows the dates I entered just fine in a text box with the following Control Source: =[Forms].[frmWhatDates].[txtStartDate] & " - " & [Forms].[frmWhatDates].[txtEndDate]



But when I click "print" this text box shows "#Name?"

How do I correct this?


Varda

[pbaldy]

Probably by leaving the form open until you close the report. It requeries when you print.

[Varda]

I feel so stupid. Yes, that was it. Thanks!

[pbaldy]

Happy to help! If you're stupid so am I, because I had the same problem when I first used forms to gather user input.