Text box and parameter values

G

Guest

Whenever I create a text box and run it, the parameter value comes up. I am
simply trying to add a field to me report without any calculations. I go to
Expression builder and select the table and field and the parameter value
always pops up, why? How do I fix this?
 
A

Allen Browne

What do you have in the Control Source property of this text box?

If it refers to a field that is not in the RecordSource of the report, you
will need to either:
a) Use DLookup() to read the value from the other table.
More details:
Getting a value from a table: DLookup()
at:
http://allenbrowne.com/casu-07.html

b) Change the report's RecordSource into a query that does contain the field
you need.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Having Expression Builder troubles - HELP!!!!!!!! 3
Report asks for Parameter and Won't Display Subreport 7
Enter Parameter Value in Access Form 0
Enter Parameter Box pops up even though its not in query 7
why does "enter parameter values" pop up in SQL query in Access? 3
Remove ''Enter Parameter Value'' 1
Conditional Prompting for Parameter? 3
How to remove ''Enter parameter value'' 1

Top