create, store and traverse my string array

[Razor]

Hi,

I want to open a recordset that will return several filter
values.

I'll need to store the values into an array and loop
through each array element using it in a query.

******************************************
Set qdf = CurrentDb.CreateQueryDef("vqryRecordsource")
strQuery = "SELECT [qryAllocationDetails].* " & _
"FROM [qryAllocationDetails] " & _
"WHERE ((([tblExpenseCodes].[Report
Client]) = 'CurrentArrayElement'))"
qdf.SQL = strQuery
With PDFObj
.ReportName = "rptAllocationDetailsPDF"
.OutputFile = "c:\'currentArrayElement'.pdf"
.PrintImage
End With
CurrentDb.QueryDefs.Delete ("vqryRecordsource")
RefreshDatabaseWindow
*********************************************

I'll need to traverse the array and reference the element
in place of 'CurrentArrayElement' in my code above.

Could you suggest how my code would loop though an array?

The array would store strings.

Thanks,
Razor