passing in array string element to recordset

[tania20]

Hi, Can anyone help me on the snytax to pass in a string element of an array to openrecordset. This is a segement of what I have so far.

......(1) to (22) here
arrTables(22) = "48MonthsFollowUp"

For i = 1 To 22

Set rs = db.OpenRecordset(arrTables(i), dbOpenDynaset)

next i

 

[PHV]

So, you open and destroy 21 instances of rs and finally open 48MonthsFollowUp.
Wahat do you really want to do ? Open 22 different recordsets ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[tania20]

oh just realised where I had actually gone wrong, I left out one index reference!...it is all good now. btw yes i was needing to open 22 recordsets (23 as it turns)