Requery in Place: How to Requery a Continuous Form in Microsoft Access Without the Focus Moving

In this Microsoft Access tutorial, I'm going to teach you how to requery a continuous form in place so that the data updates but the focus doesn't move. We will use an On Got Focus event with a Me.Recordset.Requery, and I'll also show you how to make a custom edit form with a Close event to do the same thing, but is better for large datasets. Damaris from Milwaukee, Wisconsin (a Platinum Member) asks: I have a continuous form much like your customer list form, however because I have some aggregate functions in there, it's not updateable. I can made it so I can double click to open up a single form where I can edit records individually but then when I return back to the continuous form the data doesn't update. And if I issue a requery command, it puts me back up at the top of the list. Is there any way to refresh that form and update the data without the focus moving? Silver Members and up get access to an Extended Cut of this video. Members will learn how to edit data in a non-updateable continuous form in place using one of my secret special tricks. Curious as to what the trick is? Join today! MEMBERS VIDEO:    • Requery in Place MEMBERS ONLY EXTENDED CUT...   BECOME A MEMBER: YouTube:    / @599cd   or My Site: https://599cd.com/THMember LEARN MORE: https://599cd.com/RequeryInPlace PRE-REQUISITES: Intro to VBA: https://599cd.com/IntroVBA Aggregate Query: https://599cd.com/Aggregate Not Updateable: https://599cd.com/NotUpdateable LINKS: Invoicing: https://599cd.com/Invoicing On Got Focus: https://599cd.com/OnGotFocus Modal & Popup: https://599cd.com/ModalPopup Simple Security: https://599cd.com/SimpleSecurity Open Form: https://599cd.com/OpenForm Mike's Article: https://nolongerset.com/requery-a-for... Double Double Quotes: https://599cd.com/DoubleDouble THE CODE: Me.Recordset.Requery RECOMMENDED COURSES: Access Developer 1: https://599cd.com/ACD1 FREE TEMPLATE DOWNLOADS: TechHelp Free Templates: https://599cd.com/THFree Blank Template: https://599cd.com/Blank Contact Management: https://599cd.com/Contacts Order Entry & Invoicing: https://599cd.com/Invoicing More Access Templates: https://599cd.com/AccessTemplates ADDITIONAL RESOURCES: FREE Access Beginner Level 1: https://599cd.com/Free1 $1 Access Level 2: https://599cd.com/1Dollar Donate to my Tip Jar: https://599cd.com/TipJar Get on my Mailing List: https://599cd.com/YTML Contact Me: https://599cd.com/Contact TechHelp: https://599cd.com/TechHelp Consulting Help: https://599cd.com/DevNet Twitter:   / learningaccess   https://en.wikipedia.org/wiki/Microso... https://products.office.com/en-us/access https://microsoft.com/en-us/microsoft... KEYWORDS: access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, Retain position on continuous form through requery, Refresh or requery, Form.Refresh, Form.Requery, refreshing or requerying a continuous form, Restoring a continuous form after Requery, Requery a Form in Place, Form.Recordset.Requery, requery a single record in a continuous form microsoft access, edit non-updateable form in place QUESTIONS: Please feel free to post your questions or comments below. Thanks.