"Bind a text box to a query result"

[kermitforney]

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! p>>>

 

[RoyVidar]

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

 

[SColbert]

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!

 

[TheAceMan1]

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]

See Ya! . . . . . .

 

[SColbert]

Clicked in the wrong box & started typing too quickly - many apologies