referring to a control in a subform

[rewdee]

I think there's relatively simple answer but I can't find it yet. I'm trying to display the number of records in a subform's label as:

Me.frmsub!lblRecNum.Caption = me.frmsub.RecordsetClone.recordnumber

OR

me.frmsub!form!lblRecNum.Caption=me.frmSub!Form.RecordsetClone.RecordNumber

Anyone know how I display the number of records in a label in a subform?

Thanks,
Rewdee

 

[RickSpr]

There is no RecordNumber property anywhere in Access or DAO. Do you want the total number of records in the subform's record source? That would be:
Me!frmSub.Form!lblRecNum.Caption = Me!frmSub.Form.RecordsetClone.RecordCount

In general, when working with forms, you want to use the "!" operator before the name of a control, and the "." operator before the name of a property. "Me.frmSub" is also valid, because Access makes a special case for it, but I think you'll find that it doesn't work in certain special contexts. Rick Sprague