Dear All,

I have a form which consists of six tabs, on one of the tabs(Change Log)I have a combo box that on change will refresh the whole form and this works fine. Except when I change the combo box, the form refreshes but goes back to the first record on the (Change Log)when it should go back to the record it was on when the combo box was changed.

Thanks
Mark

No doubt not the tidiest way, but at the beginning of your code, store the displayed record in variables then reload the controls after the refresh. If it's from one table, then I would use a bookmark and reload that way, or keep the record ID then use a recordset to get the data.

I am sure that someone else can help with the specifics, but that is the path that I would follow.

HTH

Simon