hi all,<BR>QUESTION ERROR I am getting an SUBSCRIPT OUT OF RANGE ERROR when trying to place field data into an array like this. I have printed out the field data so I know it exists properly but I am getting the following error when i try to dynamically create the array. I have no idea how big the array will be ahead of time so I can't simply Redim Archaeology(100) I tried. To get the information with recordcount set that number = to x and then Dim Archaeology(x) and I get a data type mismatch error. <BR>SO I have 2 questions.<BR>QUESTION 1: what is the best way to declare an array that is as big as to be determined variable X?<BR>QUESTION #2: why am I getting this subscript error. see code below.<BR><BR>ERROR<BR>Microsoft VBScript runtime error ' 800a0009' <BR><BR>Subscript out of range <BR><BR>/Default.asp, line 195 <BR><BR>SCRIPT<BR>Dim Archaeology()<BR>currentplace=1<BR><BR>rsCustomers 3.MoveFirst<BR><BR>Do While Not rsCustomers3.EOF<BR>Response.write rsCustomers3("ArcSynopsis") & "<rb>"<BR><BR>Archaeology(currentplace)= rsCustomers3("ArcSynopsis")<~~line 195<BR>currentplace=currentplace+1<BR>rsCustomers3 .MoveNext<BR>loop <BR>======================<BR><rb> is used because this message board thinks it means line break.