Counter On Continuous form 1

[kevinf2349]

Hi

I have a pretty simple form that is set up as a continuous form. It is a list of department names in the table tblDept. I would like to add a counter to each displayed record that is a count of records where the department ID matches the one displayed but in table tblContact.

I know that continuous forms are pretty restrictive so I am not sure if this is even possible....any ideas?

 

[gol4]

use a static variable to count. Something like this will be close

make text box and place
=Countrecs() as its control source

this in the forms module

Private Function Countrecs() As Integer
Static lngX As Long
lngX = lngX + 1
If lngX > Me.RecordsetClone.RecordCount Then lngX = 0
Countrecs = lngX
End Function

 

[kevinf2349]

Thanks for the pointer. It is now working like a charm