I think I will do that then. Is there anyway to manually do that such as maybe a form refresh?
So refreshing tabledef connections and recreating the connections with the [FixConnections()] function are only for if there are structural changes in the table.
Requerying the recordset will update the record source making it re-retrieve all the records and set it to the first record.
Similarly lowering the odbc refresh interval will refresh and check for changes without bringing you to the first record but is on a timer instead of on command.
Please correct me if I am wrong and thank you both so much for teaching me! I greatly appreciate it!