Display Data In Form From A Query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

GeorgeSoares - 05 Dec 2007 16:58 GMT

I have a form with the Control Source as
"=Query!QTYForPPMProduction!SumOfQTY_PRODUCED"
and this query runs prior to the form opening.
The query runs fine, and the proper data displays in the datasheet view, but
my form Text Box will not show the data.
Any suggestions out there?

Reply to this Message

Douglas J. Steele - 05 Dec 2007 17:31 GMT

=DLookup("[SumOfQTY_PRODUCED]", "[QTYForPPMProduction]")

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

>I have a form with the Control Source as
> "=Query!QTYForPPMProduction!SumOfQTY_PRODUCED"
[quoted text clipped - 3 lines]
> my form Text Box will not show the data.
> Any suggestions out there?

Reply to this Message