display qry results in text box

[ranjah]

Hello Experts,
i have this small problem with my qry results not being displayed in the text box.

tbl Issues= status field and many other fields
tbl Status= Active or Closed

here is my qry
SELECT Count(Issues.Status) AS CountOfStatus
FROM Issues
GROUP BY Issues.Status
HAVING (((Issues.Status)="Active"));

I have tried typing this code on the control source of the text box
=DCount("PartNumber","Issues","Status=Active")
but it doesnt work.

All i want to do is display my results in a text box on a form.

Any help
Thanks alot

 

[ghudson]

Searching the forum is a great way to discove and learn the answers to your Access programming questions.

DCount Function

That should point you in the right direction. Your Dcount() and the criteria is not formatted correctly.

 

[ranjah]

thanks

I really appriciate it Sir Ghudson,

Thanks