Displaying Filtered Records on a Form

[vdanelia]

Hello Friends, I have a such question..

I have a form on which is filtered records, and need to count:
I have unbound text box and put =Dcount function.. Working well counting all the filtered data..
I want also another variant which will display in such format (if the filtered data is 10 records) it must show record: 1 of 10, 2 of 10, 3 0f 10 etc.

Thank you in advanced

 

[vbaInet]

You should be using Count(*) and not DCount(). Put =Count(*) in the Form's Footer section.

=[CurrentRecord] & " of " & Count(*)

 

[vdanelia]

Greatest Thanks VBAInet

Works Perfectly

 

[vbaInet]

Glad that worked for you.