How to display text from a query into a textbox

Question

I have a textbox on my report and I have a query which always returns a single cell:

SELECT CustomMessage FROM OrderSheetSettings;

My aim is to display the single cell that it returns and place it into the textbox through the expression builder.

What I have/tried so far:

[qryCustomMessage]![CustomMessage]
[qryCustomMessage]![CustomMessage].Value

But this returns '#Name' or '#Error'

Any help on this would be great.

Thanks

score 0 · Accepted Answer · answered Oct 14 '13 at 08:58

0

=Dlookup("CustomMessage","OrderSheetSettings")

answered Oct 14 '13 at 08:58

4dmonster

1 Answers1