Using text box on a form to display the result of a query

Using text box on a form to display the result of a query

Post by SmltIEc » Tue, 05 Sep 2006 11:27:01


How do I link a text box on a form to a specific value that summarizes the
result of a query? \JG
 
 
 

Using text box on a form to display the result of a query

Post by QmFycnkgR2 » Tue, 05 Sep 2006 11:44:01

You can use DLookup or DSum and use the query for the domain argument.

For example:
DSum("fieldName","qryMyQuery")

Barry