Display Data In Form From A Query

  • Thread starter Thread starter GeorgeSoares
  • Start date Start date
G

GeorgeSoares

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?
 
=DLookup("[SumOfQTY_PRODUCED]", "[QTYForPPMProduction]")
 
You must log in or register to reply here.

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

Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Populate a form based on a query using parameters 8
Access 2003 pivot table subform 0
Show query results in form 5
Access Access Report Works on One Machine but not Another 3
Display Results from a select query in a subform 1
Combo Box Lookup Value 4
PivotChart in form display issue 6

Back
Top