TextBox (2003)

Topic

New Reply

I have a text box that I would like to be filled with the result of a field in a query that is ran. As it stands now the result #Name? is in the text box when the form is in run mode. Any help is appreciated.
Thanks

Reply | Quote

Replies

What is the current control source of the text box?

Reply | Quote

there is no control source because when i put my query in for the control source it still gives me #Name? in the textbox
If I put the following code in the control source or the default value i get #Name? in the textbox
=[quCurVac]![SumOfSumR]

Reply | Quote

Are you referencing this in the record source of the report or form? Maybe drop a boiled down version so we can have a peek.

Reply | Quote

You cannot refer to a query this way. Try

=DLookup("SumOfSumR","quCurVac")

Reply | Quote

Thanks HansV. That worked perfectly.

Reply | Quote