After edit form, return to same place on first form...

[lorirobn]

Hi,

I have a continuous form which displays all the records on a table.
The detail row has a command button which, if pressed, takes the user
to another form where that record can be edited.

The problem I'm having is what happens and what to do when the edit
form is closed. Originally, when the newly modified data was not
showing up, I added a requery in the main program's 'activate' event.
But now, when I return back to the main form, it brings me to the first
record on the table. Is there a way to come back to the same spot I
was in before going to the edit form? It is annoying to have to scroll
there each time, and I think it is good practice anyway to show the
same data upon return from the 2nd form.

Thanks in advance for any suggestions.

 

[Wayne Gillespie]

Hi,

I have a continuous form which displays all the records on a table.
The detail row has a command button which, if pressed, takes the user
to another form where that record can be edited.

The problem I'm having is what happens and what to do when the edit
form is closed. Originally, when the newly modified data was not
showing up, I added a requery in the main program's 'activate' event.
But now, when I return back to the main form, it brings me to the first
record on the table. Is there a way to come back to the same spot I
was in before going to the edit form? It is annoying to have to scroll
there each time, and I think it is good practice anyway to show the
same data upon return from the 2nd form.

Thanks in advance for any suggestions.

Try using Me.Refresh in the Activate event instead of Me.Requery.


Wayne Gillespie
Gosford NSW Australia

 

[lorirobn]

Excellent - Me.Refresh did the trick! Thanks, Wayne.
Lori
ps - goodday to you in Australia.