Execute the value of a variable 1

[ndalli]

Hi,

I am trying to write a reusable function to move the pointer within a recordset. The recordset name will be passed as a parameter. Does anybody know how is it possible to execute the value of a variable

e.g.

call fncRecordset("ClientsRecorset&quot

Public fncRecordset(passedRecordset as String)

'Where MoveNext should move to the next record
' of the recordset ClientsRecordset

'passedRecorset will have the value
'of "ClientsRecordset"

passedRecorset.MoveNext
end function


Thanks in advance

 

[Hackster]

You have your parameter declared as a String. Thats not going to work. Declare passedRecordset As Recordset and you should be good to go.