I had this button in my form and upon clicking on it the Recordset on the grid sort the names field in ascending order. The problem is that is does not reflect the actual table in Access upon sorting the recordset. I've wanted to reflect the changes made in the recordset and the table as well. This is the basis of my data report, changes in the actual table.

TIA.