to separate the sizes, use the split() function and each size would then be a different array element. you would then cycle throught the array and add each item to the list.
you could use a for each loop.
Code:
array = split(DBFIELD)
second:

use this sql statment
Code:
strSQL = "SELECT * FROM Shoes WHERE ItemNo='" & iNumber &"';"
the sql you had would look for the ItemNo that was iNumber, not the value it held. Also if the value is not an integer, you need to put single quotes around it._Also_ with your statment, only the actual ItemNo field would have been retrieved, not the whole record, which i assume you wanted.

Well, just some things to look out for. dont worry, once you do it a few times, its natural.