Hi
I have a report that is made of 4 subreports. There is no actual
information in the main report, and the record source is empty. In
the Header section of the main report, I have a text box and I want
some user input to go in there every time the report is run. I'm
putting =[Enter something:] into the control source but it comes up as
#Name? when I run the report.
If I put something in the record source for the main form, the text
box/user input bit works but for some reason my 2 page report is
repeated numerous times, depending on which table or query is in the
record source.
I know very little about SQL code or expressions... has anyone got any
ideas?
Thanks
Clare