Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Parameters on a Form

Status
Not open for further replies.

JannerB

Technical User
Dec 1, 2004
1
GB
Hi I am trying to display the input parameter from an underlying query on my Report.
I thought I just had to add = [Paramter]
To the control source of a text box in my report but I just get #Name? in my results.
I am running Access 2002 on Windows 2000.

Another quickie when using a List box on a form, I start typing the first few letters, but then want to use the up/down arrows to sdelect the field I want. This does not seem to work ( but I am sure I could do it in a previous database).

Cheers in advance
 
JannerB
Regarding your report parameter...from the title of your post, I assume you are inputting the parameter through a form.

That being the case, make an unbound text box on your report. Make its control source
Code:
=Forms!YourFormName!YourInputControl

Regarding the list box...
Once you click in the list box, the vertical scroll bar should appear.

Tom
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top