I have a frmMain with a sub-form of sfrmSecond. I included a record count on the OnCurrent event of the sfrm (Me.txtRecordCount.Value = Me.Recordset.RecordCount). I would like to reference this on the main form and then disable a command button if the record count exceeds 21. I tried to follow this code (from a thread on this topic) (Create text box on subform and referencing it on main form
Forms!frmMyForm!SubFormControl.Form.RecordsetClone.RecordCount) to include the count on the main form without success.
Can you provide some insight into how I am supposed to reference the count on the main form?
Thank you
Forms!frmMyForm!SubFormControl.Form.RecordsetClone.RecordCount) to include the count on the main form without success.
Can you provide some insight into how I am supposed to reference the count on the main form?
Thank you