Record Count

T

Tom

How can I make a text box show the record count? I thought I could go to the
properties of the text box and under Control Source type in =Count([Ponum)]
and it would count the field. It works the way I typed it one time but then
gives me an error in the text box when I go out and back in.
 
F

fredg

How can I make a text box show the record count? I thought I could go to the
properties of the text box and under Control Source type in =Count([Ponum)]
and it would count the field. It works the way I typed it one time but then
gives me an error in the text box when I go out and back in.
Click to expand...

On a Form?.

Both of these work for me.
= Recordset.RecordCount
or
=Count(*)
 
T

Tom

I searched everywhere for the remedy. I should have shopped here first.
Thanks

fredg said:
How can I make a text box show the record count? I thought I could go to the
properties of the text box and under Control Source type in =Count([Ponum)]
and it would count the field. It works the way I typed it one time but then
gives me an error in the text box when I go out and back in.
Click to expand...

On a Form?.

Both of these work for me.
= Recordset.RecordCount
or
=Count(*)
Click to expand...
 
Top