Go back to current record (1 Viewer)

[mark curtis]

Dear all,

I have a form with 6 tabs. When I am in tab3 I have a form1 which has a combo box...and subform2 that stores multiple change requests. In the AfterUpdate event of the combo box I ask it to refresh tab1 and it works fine except one thing. I may be in record 3 of subform2 when I select the form1 combo box the focus always returns to the first record of subform2. I need to sort of bookmark the record I am in when I select the combo box?

Any help as usual much appreciated.

Mark

 

[ntp]

Dim varBookmark as Variant

To record a bookmark
varBookmark = rst.Bookmark

To set the current record to the bookmark

rst.bookmark = varBookmark

You can decide which controls and events need to handle this sort of thing.

ntp