I have the following code in the form's 'Form_Current" event to display the number of records in a text box.
is there a way to use this same code, modified, for distinct?
Background: the form is actually a subform (subGroupIntervention) and on it is a subform (subGroupIntervention_Tool
There's a one-to-many relationship between the Intervention and Tool (henc why the above form to subform is used).
My problem: when the code snippet below runs, if there is one intervention and three tools, the recordcount is three, not one. I want it to show for only one intervention...
BTW, the main form (frmGroupMain) filters for the GroupID so that you only seen Intervnetions for that Group.
Set rs = Me.RecordsetClone
Me.txtRecCount = Me.CurrentRecord & " of " & rs.RecordCount