Calculating total number of records

[little_rascals]

Hi, i have a form, frmSearch which allows me to search for fields an
criteria. After selecting the fields and entering the criterias, th
results which i want will be generated.
I need to reflect the total number of records generated for that searc
in a textbox.
Can someone kindly tell me how i can go about doing it??

Thank You!!

+----------------------------------------------------------------
| Attachment filename: sample_.zip
|Download attachment: http://www.MSAccessForum.com.com/forums/attachment.php?postid=213926
+----------------------------------------------------------------

 

[Tanis]

I have not been able to download the zip file, as our firewall ha
prevented it. Anyway, create a text box and in the control source ente
=DCount("*","YourQueryName")

Davi

 

[little_rascals]

Hi David,

I've tried yr method but it doesnt seem to work for my case.
=DCount("*","YourQueryName")

Because the search results are generated on a listbox on the form
frmSearch instead of a query therefore, i actually changed th
statement to:
=DCount("*","MyListboxName")

However, this does not work! :