jharding08
Member
- Local time
- Today, 09:58
- Joined
- Feb 16, 2021
- Messages
- 55
Is it possible to take a RecordsetClone of a subform(filtered) and then in VBA, query on the distinct values of that recordset?
--------------------------------------------------------------------------------------
Set rs_Clone =Me.subfrm.Form.RecordsetClone
/**Set another recordset (rs_Cust) to Get Distinct CustID from rs_Clone**/
Do until rs_Cust.EOF
Do Stuff
Loop
------------------------------------------------------------------------------------------
I dont want to use the recordsource and filter of the subform, just the resulting recordset after filtering
--------------------------------------------------------------------------------------
Set rs_Clone =Me.subfrm.Form.RecordsetClone
/**Set another recordset (rs_Cust) to Get Distinct CustID from rs_Clone**/
Do until rs_Cust.EOF
Do Stuff
Loop
------------------------------------------------------------------------------------------
I dont want to use the recordsource and filter of the subform, just the resulting recordset after filtering