Check to see if the data environment has the property set to open the tables. If not, it could be that the table just happens to be open from the form or code prior to running the report so it just keeps the same order that was set.