ParamArray allows only 1-dimension array, need 2-dimension in order to pass both field values and field names. Explore methods of building and passing 2-dimension array. An alternative is to open a recordset object filtered for the one record and read field values and names into array for bubble sort.