Control Source

  • Thread starter Thread starter Tom T
  • Start date Start date
T

Tom T

In a report:

I am trying to have a text box = a # (Count) from a query,
but I keep getting a (#name?) error. Any suggestions on
how to fix this problem?

TIA,
Tom
 
Tom,
How about letting us know the exact expression you are using, as well as the
name of the control in the Report.
 
Tom,
I assume [Inbounds Loads Totals] is the name of the query, and it returns
just the one record.

Use a DLookUp.
=DLookUp("CountOfInbound Driver/Carrier","Inbounds Loads Totals")

Make sure the name of the control is not 'CountOfInbound Driver/Carrier'.

--
Fred

Please reply only to this newsgroup.
I do not reply to personal e-mail.


Tom T said:
Here is the expression that I am trying to use.

=[Inbounds Loads Totals]![CountOfInbound Driver/Carrier]

Thanks for the help,
Tom
-----Original Message-----
Tom,
How about letting us know the exact expression you are using, as well as the
name of the control in the Report.

--
Fred

Please reply only to this newsgroup.
I do not reply to personal e-mail.





.
Click to expand...
Click to expand...
 
Back
Top