473,320 Members | 1,831 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Return to The Same Record After Closing a Form

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.

3 2089
Rabbit
12,516 Expert Mod 8TB
It shouldn't do that unless you're closing the members form in the interrim.
Oct 1 '12 #2
Tempo
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
Tempo
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

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

Similar topics

9
by: David Allison | last post by:
cmdButton to Print 3 copies of record in Form view ? cmdButton will print 1 but I need 3 copies of the one Form record. -- Dave Allison
1
by: Uros | last post by:
When closing some forms in MSAccess 2003 Access is crashed (Microsoft Office Access has encounteres a problem and needs to close. We are sorry .......). If I close form without changes work OK, but...
2
by: RobertK | last post by:
Hi i wonder how to avoid (trap) closing Form when user clicks 'X' button in right-top corner of the form. has anybody idea how to do it? thanks in advance. Regards, Robert
8
by: Ragbrai | last post by:
Howdy all, I have a form for entering data (Form A), on which is a cmd button that opens Form B in acdialog mode to allow me to enter/edit records that are being displayed on Form A. After...
1
by: Rathi R | last post by:
Hi, I am new to this forum. I am working on Ms-Access. Based on the data in various tables i am generating a form. In that form, the calculated values have to be displayed one after the other i.e as...
6
by: CoolRiyaz | last post by:
I want to return record number with my query output. I dont' want to use IDENTITY function and temp table for this purpose as I am dealing with very huge data. any suggestions...
2
by: Tom Clavel | last post by:
Scratching my head. I am using the filter property on a combo box .AfterUpdate event to get to a single client record. This is causing a some strange behavior: As I enter a subform, I get a no...
4
by: barkarlo | last post by:
I use check box in a form "frmworkorder" like confirmation that's record finish. How can I write code who will block edit and delete record in form when is check box confirmed.
5
by: HawkMan24 | last post by:
I submitted this on another PHP/Ajax forum and no one was able to figure it out. I am trying to return to a form from Ajax after clicking on a PayNow button and I want to return true or false...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.