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]

Re: User Input in an Access Report?

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" <clare.jenner@c ambridgeshire.g ov.uk> wrote in message
news:af193fa0.0 404140653.40fda a7a@posting.goo gle.com...[color=blue]
> 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[/color]

[Rick Collard]

Re: User Input in an Access Report?

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

=InputBox("Ente r something","My Title")

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

Rick Collard

https://www.msc-lims.com

On 14 Apr 2004 07:53:23 -0700, clare.jenner@ca mbridgeshire.go v.uk
(Clare) wrote:
[color=blue]
>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[/color]

[Clare]

Re: User Input in an Access Report?

nospam@nospam.n ospam (Rick Collard) wrote in message news:<407dde57. 16205261@news.w est.earthlink.n et>...[color=blue]
> Try using the InputBox function in the control source property of your
> text box:
>
> =InputBox("Ente r something","My Title")[/color]

That works perfectly! Thank you very much :o)

Clare