Count of records

[Bruce]

I have a main form that provides user controls. Within the main form I have a subform that displays a form/query result in worksheet mode that displays current active workorders. I want to put a text box on the main form that counts the total number of workorders (SID) displayed by the form/query. At this point I have a textbox and have set the control source to:



=Count([Forms!Active_WorkOrders_Query!SID])

but get a #error message, any ideas?

Thanks

[RuralGuy]

In situations such as this I tend to use the Current Event of the SubForm to get the RecordsetClone.RecordCount after doing a .MoveLast. Then place the value in a control of the SubForm Footer. The Footer will not show in DataSheet view and you can fetch it from the MainForm if you want.

[Bruce]

Heavy dude! I'll have to work on this one :-) Thanks!

[RuralGuy]

Post back here if you are still having problems.