Text box and parameter values

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

KenJ - 15 Jun 2007 05:03 GMT

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?

Reply to this Message

Allen Browne - 15 Jun 2007 05:52 GMT

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.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> 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?

Reply to this Message