This is an Access 2000 ADP with SQL Server 2000.
I have a calling form in COntinuous mode. Multiple rows display after filling the RecordSource property with a SQL string using a one to one relationship between table A and table B. Upon double clicking a row we open a second form in single mode using a SQL String just using Table B fields. After closing the second form we return to the Calling form. Since the calling form has fields from Table A and Table B we need to "update" the data in those controls so it reflects the change just carried out. To do that, we do a Me.Refresh. The controls update as expected, but the row that had the focus (from the initial double-click) is now the first row displayed at the top of the form. So the rows have scrolled up, if you will, apparently as a result of the refresh.
So, is there a way to "update" the controls without causing this scrolling?