I'm using a VIEW of all records to edit on in a form. I have the ControlSource properties of all controls set the view. Then I TableUpdate() and it posts to the real table ok. However, to get the View to be refreshed to the new record I issue a Requery but it them moves my record pointer to the first record in the View.

I also tried just Refresh('view') but that doesn't refresh the record in the view that is currently displayed.

I'm just switching to Views from too many years of buffered table problems.

What am I doing wrong?