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!

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

"Bind a text box to a query result"

Status
Not open for further replies.

kermitforney

Technical User
Mar 15, 2005
374
US
I am trying to bind a text box to the result of a Sum query.
I have tried to do it but I think the only way is through the Expression Builder.

Is this the only way to do it?
If so what are some other techniques?

If not how do I build the Expression?
I have tried but I can't get the result to display in the field. I keep getting the #Name? error.

<<<I hate that error, it's my least favorite! :eek:p>>>
 
You will need to open a recordset or use one of the Domain Aggregate functions (DLookup, DMax, DSum...), if I'm not mistaken.

Roy-Vidar
 
I have a form "Golfers" based on a table "Golfers" containing golfer information and a form "Sponsors" based on a table "Sponsors" containing sponsor information (forms are linked many Sponsors to one Golfer via GolferID).

I have an unbound text box on the Golfers form where I'd like to show the total amount pledged for that golfer. I've created a Sum query that's working, but can't figure out how to get the Pledge Total field from this query to show up in the unbound text box on the "Golfers" form - just shows #Name? error.

I know the solution should be simple, but I can't seem to wrap my head around it. Help!
 
How are ya SColbert . . .

Its not fair to the thread originator to mix resolutions!

You should start your own thread! . . . doing so has great benefit for you:
[ol][li]You expose your problem to the [blue]entire forum![/blue][/li]
[li]The [blue]entire form will benefit from any resolution[/blue] of your problem along with those who pass by.[/li]
[li]You can [blue]catch more guru's[/blue] with your own exposed thread, and [blue]reach resolution faster[/blue].[/li]
[li]As you've posted here, you'll remain buried, with no exposure at all![/li]
[li]In short . . . start your own thread for maximum exposure and benefit to you! ;-)[/li][/ol]

Calvin.gif
See Ya! . . . . . .
 
Clicked in the wrong box & started typing too quickly - many apologies :)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top