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 EXTENDE...  

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.