User Input in an Access Report?

[Clare]

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

[DC Fan]

You may want to simply build an input form that asks the user for the input
and then, when the user clicks "Go" or something, populates the report.

Hope this helps.

-DC Fan

"Clare" <cl**********@cambridgeshire.gov.uk> wrote in message
news:af**************************@posting.google.c om...

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

[Rick Collard]

Try using the InputBox function in the control source property of your
text box:

=InputBox("Enter something","My Title")

Take a look at the InputBox function in Help for a description of its
available parameters. HTH

Rick Collard
www.msc-lims.com

On 14 Apr 2004 07:53:23 -0700, cl**********@cambridgeshire.gov.uk
(Clare) wrote:

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

[Clare]

no****@nospam.nospam (Rick Collard) wrote in message news:<40***************@news.west.earthlink.net>.. .

Try using the InputBox function in the control source property of your
text box:

=InputBox("Enter something","My Title")

That works perfectly! Thank you very much :o)

Clare