count on filter

[Aliffi]

Dear All,

i have a little problem

i want to count all records on the form

it is working , but when i apply filter it does not count the filterd records it just conts all of reocrds always

regards

 

[willir]

In the previous solution provided, by changing the record source of the form, the record set is changed so only "filtered" records are shown. Your record count will be accurate.

 

[ZmrAbdulla]

This should work after filtering also.

[COLOR=blue]=Count([FieldName])[/color]

This will be controlSource of a textbox placed on the form.
BTW What code are you using?

Zameer Abdulla
[sub]Jack of Visual Basic Programming, Master in Dining & Sleeping[/sub]
Visit Me

 

[Aliffi]

it is ok with only access form

but it does not work with access project form

ADP

can you check plz


regaards

 

[ZmrAbdulla]

I don't know ADP / DAP!!
Microsoft: Access Project (ADP) Forum forum958 may be best for your question

Zameer Abdulla
[sub]Jack of Visual Basic Programming, Master in Dining & Sleeping[/sub]
Visit Me

 

[Aliffi]

It does not work mannnn

i used recordsetclone , recordcount

everything but not working


any one can findout plz

 

[ZmrAbdulla]

To remind you again.... post your question to Microsoft: Access Project (ADP) Forum Forum958 may be best for your question

________________________________________
Zameer Abdulla
Visit Me
The best thing to spend on your child is your time.