How do I put the result of a count query into a form? 2

[boysrus]

I want to put a count value into a form. I have created a query called qryOutLoanerCount. There are no groupings so it comes up with 1 count field called [CountOfUnits]. I am trying to show the value of this count field on my form. On the form, I have a text box with the Control Source set to: =[qryOutLoanerCount]![CountOfUnits]

However, when I look at the form in formview I only get: =Name?

Can anyone tell me what I am doing wrong?

 

[JoeMiller]

Try this instead:

=DLookup("[CountOfUnits]","qryOutLoanerCount&quot

HTH Joe Miller
joe.miller@flotech.net

 

[boysrus]

Works Great!!! Thanks.!!!

 

[SyedAqif]

U can also draw a list box and adjust its size so that it looks like a text box and in its row source u can mention ur query

Cheers!
Aqif

 

[JoeMiller]

Good idea aqif, I like that! Joe Miller
joe.miller@flotech.net