Try
=DLookup("[myresult]","[qry_101_calcresult_net]")
Duane Hookom
MS Access MVP
> To: MS_Access_Professionals@yahoogroups.com
> From: buffalome000@yahoo.com
> Date: Tue, 21 Aug 2012 00:06:54 +0000
> Subject: [MS_AccessPros] Unbound text box on unbound form. I need the result of a query in it
>
> I have a form unbound.
>
> I have a query that results in a single number, called Myresult.
> I would like to just pull it in to a text box, but I cant seem to figure a way to do it.
>
> I tried
> =[qry_101_calcresult_net]![myresult]
>
> But that does not work.
> All I can figure out is to change the query into a make table and grab it that way, or make a very very tiny subform with 1 field.
>
> anyone have ideas ?
>
> by the way, to Bill or whomever is moderating, it's me terence of buffalome90210, AGAIN i had to create a new act...so I am now buffalome000, appropriate LOL
>
> Thanx in advance.
>
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar