devxlogo

Utilize Move Function in DAO Recordset to Refresh the Current Field List

Utilize Move Function in DAO Recordset to Refresh the Current Field List

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.

devx-admin

Share the Post: