In DAO recordset, there is no separate refresh command to refresh the current recordset. However, you can call Move member function to position the recordset lRows records from the current record. This function is used to move forward or backward in the record set and also to refresh the current filed values. Move (1) is equivalent to MoveNext, and Move (-1) is equivalent to MovePrev. You can also issue Move with parameter AFX_MOVE_REFRESH, which is which is equivalent of calling Move with parameter value 0 to refresh current field values. Thus, calling Move (0) is better instead of calling MoveNext and MovePrev.
Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.
