Return to The Same Record After Closing a Form

[Tempo]

I have a form named "frmMembers " with a command button that opens another form named "frmViewReports ". Whenever I close "frmViewReports ", "frmMembers " automatically goes to the last record (Member) in frmMembers.

I would like to be able to return to the same record that was displayed prior to opening and closing "frmViewReports ).

[Rabbit]

It shouldn't do that unless you're closing the members form in the interrim.

[Tempo]

Hi Rabbit,

Thanks for the response. "frmMembers " remains open as indicated on the "Tab Control" and "frmViewReports " opens on its own "Tab". It's just that when I close "frmViewReports " it appears to automatically perform some type of requery action and ends up displaying the last record in the recordset.

I can't understand it unless I have an unknown procedure in one or both of the forms in question.

Thanks again for trying, though.

[Tempo]

Hello again Rabbit,

Problem resolved. Discovered some overriding code in "frmMember" 's On Activate Property.

Once again, I'm grateful. Your response motivated me to dig a little deeper. Thanks! And the best of success in life for you.