In A2K I
- use field inputs on a mainform to dynamically create an SQL statement
- pass the SQL to an ADO .Open
- assign the resulting recordset to subform.form.recordset
where subform is in datasheet view on mainform.
When a line is selected on the subform a detailform is opened with that record. If changes are saved to the record, I requery the subform so that the visible changes are displayed. This causes the cursor to go back to the first record on the subform.
I want to have the cursor stay at (or near) the record selected on the subform. When I tried using the subform.bookmark, things got a little goofy.
What is the relationship between the subform.bookmark and
recordset.bookmark? And between the subform.currentrecord and recordset.currentrecord?
Can the recordset.currentrecord be something other than the one highlighted on the subform?