Forum Discussion
kvhmir
Feb 17, 2022Copper Contributor
Recordsetclone gives empty recordset
I have code below which is in the Form-Load. According help, the Form-Load-event is triggered after the records have been loaded. However, the Set rs = Me.Recordset retrieves no records at all. I al...
arnel_gp
Feb 17, 2022Iron Contributor
maybe got to do with your OpenArgs, what is the value passed?
you need a Fieldname to filter it.
and I believe this is from the Load event of the subform?
strSplit = Split(Me.Parent.OpenArgs, "€€€€€")
Me.Filter = "theField = '" & strSplit & "'"
Me.FilterOn = True
you need a Fieldname to filter it.
and I believe this is from the Load event of the subform?
strSplit = Split(Me.Parent.OpenArgs, "€€€€€")
Me.Filter = "theField = '" & strSplit & "'"
Me.FilterOn = True