BACK to current record after Requery ???

[accesscomthomas]

i'm deleting some records in subform after a combobox selection in mainform. However, after Me.requery (in the mainform combobox afterupdate), the mainform always go to the first record !!!!

HOW could i go back to the CURRENT record in MAINFORM ???

 

[ByteMyzer]

Instead of Me.Requery, why don't you try something like Me.subform.Form.Requery?

 

[accesscomthomas]

OH ..... so simple

i spent a whole night on it !!!!!

anyway, is there any method i could know the current record offset ?

 

[Pat Hartman]

The current record offset is meaningless in a relational database. You can use a bookmark to keep track of a record so you can go back to it. However, bookmarks are not valid after a requery so the only way is by keeping track of the record's primary key and using a find to reposition the recordset. If you search for "recordsetclone", you should see examples both here and in help.