QUERY VALUE TO TEXT BOX

  • Thread starter Thread starter Rpettis31
  • Start date Start date
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.
 
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
 
Back
Top