Hello,
I have a continuous form on which the user can navigate through record. When found, the user can click on a record to view or edit it (nothing new here).
The continuous form (let’s call it LogHeader) is a subform of a form (LogList) and on the form there is a header than contains filters.
The user can use the filter, to filter record element for easier and faster analysis. When using filters, and upon clicking “save” and close, I would like the user to be able to see its updated record on the continuous form.
I tried the Forms!LogList.Refresh and Forms!LogList.Requery but neither would place the “current record” first (using the Forms! Because the code is running on the editing form).
I saw many times the possibility to use the Me.Bookmark or the rs.findfirst but in the last instance I am confused with what shall be the rs in my situation. (like here for example: Jump to a specific record in a continuous form | Access World Forums (access-programmers.co.uk))
As I mentioned the code is running on the editing form and neither on LogHeader nor LogList (maybe that’s the issue). Or maybe the use of the filter shall be included in the mix.
Thanks.
Bob
I have a continuous form on which the user can navigate through record. When found, the user can click on a record to view or edit it (nothing new here).
The continuous form (let’s call it LogHeader) is a subform of a form (LogList) and on the form there is a header than contains filters.
The user can use the filter, to filter record element for easier and faster analysis. When using filters, and upon clicking “save” and close, I would like the user to be able to see its updated record on the continuous form.
I tried the Forms!LogList.Refresh and Forms!LogList.Requery but neither would place the “current record” first (using the Forms! Because the code is running on the editing form).
I saw many times the possibility to use the Me.Bookmark or the rs.findfirst but in the last instance I am confused with what shall be the rs in my situation. (like here for example: Jump to a specific record in a continuous form | Access World Forums (access-programmers.co.uk))
As I mentioned the code is running on the editing form and neither on LogHeader nor LogList (maybe that’s the issue). Or maybe the use of the filter shall be included in the mix.
Thanks.
Bob