By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,251 Members | 2,727 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,251 IT Pros & Developers. It's quick & easy.

User Input in an Access Report?

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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

Nov 12 '05 #2

P: n/a
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


Nov 12 '05 #3

P: n/a
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
Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.