using control source on query result

[Bill Agee]

I have a text box whose control source is set = SumPayment_qry! SumofPayment
that was created by the Expression Builder.
Yet when I opened the form "#Name" shows up as the result. I checked the
query and the SumofPayment value is good,
soI don't understand the error message?

[PC Datasheet]

Re: using control source on query result

Bill,

You can't pull a value directly out of a query like that. The way to do it is:
=DLookup("[SumPyment]","SumOfPayment ")

Be aware that if your query returns more than one row, this expression will get
only the first row.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
resource@pcdata sheet.com

https://www.pcdatasheet.com

"Bill Agee" <wscs@mindsprin g.com> wrote in message
news:xqBHc.1363 0$yy1.11889@new sread2.news.atl .earthlink.net. ..[color=blue]
> I have a text box whose control source is set = SumPayment_qry! SumofPayment
> that was created by the Expression Builder.
> Yet when I opened the form "#Name" shows up as the result. I checked the
> query and the SumofPayment value is good,
> soI don't understand the error message?
>
>[/color]