Code problems

[GregSmith]

I have the following string:
SearchString = "checkpoint;firewall;serverA;serverB;serverC"

Under normal code, I would use:

For I = 1 To 5
MsgBox Entry(I, SearchString, ";")
Next

This would pull out each word from my string.
is there a simple way in MS Access to do this?

 

[Kodo]

SearchString = "checkpoint;firewall;serverA;serverB;serverC"

SearchArr=Split(SearchString,";")

For I = 0 To Ubound(SearchArr)
   
    MsgBox SearchArr(i)

Next

 

[GregSmith]

That did it

I had the split working but could figure out the for next statement.
Thanks for the quick reply!