By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,466 Members | 1,772 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,466 IT Pros & Developers. It's quick & easy.

Return to The Same Record After Closing a Form

P: 10
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).
Oct 1 '12 #1

✓ answered by Rabbit

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

Share this Question
Share on Google+
3 Replies


Rabbit
Expert Mod 10K+
P: 12,315
It shouldn't do that unless you're closing the members form in the interrim.
Oct 1 '12 #2

P: 10
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.
Oct 1 '12 #3

P: 10
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.
Oct 1 '12 #4

Post your reply

Sign in to post your reply or Sign up for a free account.