Gustav Brock
Gustav at cactus.dk
Mon Mar 17 10:19:34 CDT 2008
Hi Rocky If ReDim Preserve mudTH(1 To 1) works, I would first calculate UBound(mudTH) - lngDeletes in a variable and then use that. /gustav >>> rockysmolin at bchacc.com 17-03-2008 16:09 >>> Dear List: I am getting an error 10 - This array is fixed or temporarily locked - when executing: ReDim Preserve mudTH(1 To UBound(mudTH) - lngDeletes) where Ubound(mudTH) = 41 and lngDeletes = 40. The conditions which would cause this as listed in the Help do not seem to apply in this case. Access, being what it is, the error may not be exactly descriptive. Does anyone know of other reasons why you might get this error on a ReDim Preserve? MTIA Rocky