 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / November 2007How to Requery a form without losing the current record
Hello i have a main form which looks at all my records. another seperate form, not a subform, can create new records in my main data for the first form. the problem is that the main form doesnt update with the new records unless i requery it. when i do that the main form moves to the first record. i want it to stay on the record i was viewing last. how? >Hello > [quoted text clipped - 6 lines] > >how? You'll need to store the Primary Key value of the current record in a VBA variable, and use code to navigate to that record after the Requery. John W. Vinson [MVP] Hello so basically i would have to use the code to do the same as a find record combo box, but using a variable i designate. great, thanks for the help. :) > >Hello > > [quoted text clipped - 11 lines] > > John W. Vinson [MVP] |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.