Dear all,

can anyone tell me what code i need behind the onchange function of a combo box to do the following:

I update tab(1) based on a selection combo box on tab(3) using frms!frmname.refresh. i have a subform on tab(3) so when i select the combo box I may be on subform record three but when I refresh using the combo box i go back to record one.

I need to return to the active/current record i was in when i activate the combo box.

Thanks
Mark

Using code: when you click on the tab(3) you may want to set the bookmark in a variable.

Option Explicit
dim CurBookMk as Variant
public sub page3_click()
CurBookMk = me.Bookmark
end sub

public sub page1_click()
me.bookmark = CurBookMk
end sub
'set the bookmark initially
Private Sub Form_Load()
CurBookMk = me.Bookmark
End Sub



[This message has been edited by pdx_man (edited 01-25-2001).]