count records... 1

[jonra]

in my subform,a car number hav mani records..how can i count them n list the number in the main form?pls help..thanks

 

[danvlas]

In your subform footer, create a calculated textbox (NoOfRecords), with the controlsource:
=Count(*)

In your main form, create a calculated text box with the control source:
=[SubformName].Form![NoOfRecords]

Good luck




Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[jonra]

thanks dan..its workin..

 

[jonra]

another question..i wan to pop up a form if the value is equal or greater than 3...how will the coding goes?..