Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Query Result as a control source for Unbound TextBox in a form

Status
Not open for further replies.
Danglez

Danglez

Technical User
Jul 13, 2004
29
US
I have a Query named "Branch Sums" that looks like this:
Branch Maturity Date SumOfCashflow
GCI 7/22/04 ($5,000,138.89)
IBF 7/22/04 ($5,000,138.89)
NY 7/22/04 ($5,000,138.89)

I would like to create three different text boxes for each branch on my form that displays each respective amount. Or be able to display this information on my form in the following format:
NY GCI IBF
"Sum" "Sum" "Sum"

I have attempted to use dlookup to do this but I'm a newbie and it has not been working.

Any ideas??
Thank You

 
Status
Not open for further replies.

Similar threads

SamuelR
  • Locked
  • Question
Dlookup in a report
Replies
13
Views
585
dhookom
dhookom
PrimoSteve
  • Locked
  • Question
Print Report from a Subform (Tab form) in a Main Form
Replies
1
Views
199
dhookom
dhookom
RonMcIntire
  • Locked
  • Question
Adding variables to a control in a footer 1
Replies
4
Views
300
sxschech
sxschech
PLCBeetle
  • Locked
  • Question
Pass Form value to Report Record Source
Replies
4
Views
238
dhookom
dhookom
JimStrand
  • Locked
  • Question
Expression Limit on Sum IIf In Method ? Used in Report Calculation
Replies
1
Views
520
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top