ADO Data Control, Updating and Refresh 1

[RollingMoose]

I have an ado data control on a form which is bound to various text boxes. Due to the joins that are part of the query for the control, the user may click an Update button which will update the recordset and also run a refresh to display any changes. If the user is on a record other than the first, when the refresh runs the user is sent back to the first record. Is there a way I can run the refresh and keep the user on their current record? Any advice is greatly appreciated.

 

[TomKane]

I mustadmist I don't know if there is a way of doing as part of the refresh option.

If you have a unique identifier then you could try using the .find method after the refresh:

rsADO.Find "FKAccountTypeCode = '" & strVariable & "'", 0, adSearchForward

Hope it helps...

 

[RollingMoose]

TomKane........Thanks for the suggestion. Sometimes it takes someone else just to look at things from a different perspective. I used that method and it does what I need. Thanks!