Add a particular record from a table to a report text box

[Guest]

I have a report that is generated from a query. The record that I would like
to add does not come from the same table and query that generates this
report, but from another, seperate table. I ultimately will use this value
as a constant in a calculation on the report. I started to use an SQL
statement in the control source section of the text box, but I get a "No Such
Field in the Field list" error.
This is my SQL code:
Select [MaxLimit] From Tables![LimitTable] Where TestNum = 10
Where MaxLimit is the record (or column of the LimitTable table), LimitTable
is the table, and TestNum is the record (or Row in the LimitTable Table)

Am I going about this the correct way? TIA

 

[Larry Linson]

You can use the DLookup function in the Control Source.

Larry Linson
Microsoft Access MVP

 

[Guest]

Thanks Larry!
I'll Give this a shot!

You can use the DLookup function in the Control Source.

Larry Linson
Microsoft Access MVP

I have a report that is generated from a query. The record that I would like
to add does not come from the same table and query that generates this
report, but from another, seperate table. I ultimately will use this value
as a constant in a calculation on the report. I started to use an SQL
statement in the control source section of the text box, but I get a "No Such
Field in the Field list" error.
This is my SQL code:
Select [MaxLimit] From Tables![LimitTable] Where TestNum = 10
Where MaxLimit is the record (or column of the LimitTable table), LimitTable
is the table, and TestNum is the record (or Row in the LimitTable Table)

Am I going about this the correct way? TIA