dim rsSearch as Object
'clone the recordset of an open form
Set rsSearch = [Form_Customer Browser].RecordsetClone
find first record <<< how do I do this? >>>
Do Until rsSearch.EOF
goto next record <<< how do I do this? >>>
Debug.Print "Contents of field01" & rsSearch.field01
<<< what is the syntax for address in a field in a recordset object >>>
Above is a function I am trying to write.
I clone the RecordSet of an open form and then Loop through the records.
The correct use of the FindFirst and FindNext methods eluded me.
Also, how do I address the fields inside the RecordSet?