How to count the number of records in tabular form?

[hijacked101]

I have made a new form based of a query which is searching for records with a specific status.

I am trying to wrap my head around how to count the number of records returned automatically to be used in aother forumla.

I am not sure if it is a query or some coding needing to do this,so please feel free to correct me if i got this wrong.

Im not 100% sure how to starts this, but if it was coding i would imagine it would be somehting like this:

me.textbox.value = SumOfRecords

Its just getting the extact reserved words to do this.

anyone able to shed some light on this?

Thanks.

 

[KenHigg]

Maybe you can use dcount() to do this - ?

 

[hijacked101]

Maybe you can use dcount() to do this - ?

argh im an idiot.

thanks ken.

 

[KenHigg]

argh im an idiot.

thanks ken.

Bit harsh -

Glad to help -