=Count(MySubformDatasheetRecords)

[jerseyboy]

Is there a simple way to put this type of statement in an Unbound Text Boxes Data Control property?

Thanks for your advice JerseyBoy
Remember: self-praise is no recommendation

 

[Darrylles]

Hi Jersey,

Place an hidden textbox on the subform that contains the count.

Then refer to it from the main form with:

mycount = Forms!frmMain!frmSubform.Form.txtHidden

Regards,

Darrylle "Never argue with an idiot, he'll bring you down to his level - then beat you with experience."