Text box and parameter values

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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.
 
Back
Top