QUERY VALUE TO TEXT BOX

R

Rpettis31

I AM BRAIN DEAD AND IT HAS BEEN AWHILE SINCE I HAVE DONE ANYTHING IN ACCESS.
I have a query that sums up receipts and I would like to display that value
on a text box on my form (txtTotalOH).

I tried to set the control source to the query but I am getting a #Name?
error.
 
V

vanderghast

If the FORM has already its *RecordSource* property set to something else
than the query, the easiest way to get the data out of the query is to
assign the ControlSource to a DLookup:

=DLookup("SumOf...", "queryName")


Vanderghast, Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word OLE to check spelling in text box 1
Split form 0
Link a text box based on drop down box with four options MS Word 365 0
OLE Word spelling 0
Creating a Chart on form from selected data in query. 0
DLookup in Continuous form 0
How do I set focus (and select text) on a text box on a modeless userform? 0
showing just the latest value in a text box 3

Top