Problem creating an array in VB for Crystal Rpts10

[ChesterHargrove]

I am reading a table in PSQL v9.1. I want to select certain item numbers out to put in an array to use later in my Crystal Reports as separate subreports. I am a newbie to VB, here is what I have so far:

Dim BOMIems() as String
Dim Index as Number
Index = 0
Dim TableItem as String
TableItem = {ReportRecords.Forkey18_2}
 
Do While    {ReportRecords.Forkey5_4} = "F"
  BOMItems(Index) = TableItem
  Index = Index + 1

Please help me, I am at a loss and I have already used up my deadline.
Thanks anyone!

[Killer42]

Dim [B]BOMIems[/B]() as String
Dim Index as Number
Index = 0
Dim TableItem as String
TableItem = {ReportRecords.Forkey18_2}
 
Do While    {ReportRecords.Forkey5_4} = "F"
  [B]BOMItems[/B](Index) = TableItem
  Index = Index + 1

You didn't tell us what the problem is. I see, though, that you've used two different names for the same array.

[ChesterHargrove]

You didn't tell us what the problem is. I see, though, that you've used two different names for the same array.

Thank you for responding Killer42. The problem is I don't know how to complete my DO WHILE Loop. Also, don't know if my logic is right to
accomplish my results.
Thanks

[Killer42]

Thank you for responding Killer42. The problem is I don't know how to complete my DO WHILE Loop. Also, don't know if my logic is right to accomplish my results.

I hope someone else can help with that, as I'm not familiar with Crystal Reports at all.

For example, the {ReportRecords. Forkey18_2} means absolutely nothing to me.