Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   TechHelp   Help   Contact   Merch   Join   Order   Logon   Forums   
 
Home > Forums > Access Forum > Requery Help by Lee Shastid
Back to Access Forum    Comments List
Upload Images   @Reply   Bookmark    Link   Email   Next Unseen 
Requery Help
Lee Shastid 
    
10 hours ago
I have a form that enter new data into and it feeds to a continuous form. I want to requery the continuous form when I leave the current record and go to enter the NEW next record. Right now when I leave the current record the continuous form does not update unless I close out the current record. What event and where do I do the requery. I have the requery tech help video but I don't go into my form like Richard shows in the video. That's where I am confused.
Raymond Spornhauer  @Reply  
          
9 hours ago
Use the Form's AfterUpdate Event

Me.Requery

-Raymond
Donald Blackwell  @Reply  
       
9 hours ago
Is the continuous form a subform in the current form or an external form completely?

Richard has several TechHelp videos on that go over Requery techniques so it is hard to guess which method you're referring to:

Refresh v Requery
Requery in Place
Requery Subform
Immediate Refresh

And many other videos that include requerying.

You could have your main form requery the continous form everytime you move to a new record. Or you could have it requery when you add or update any record. (and have the continuous form focus on the record you just added/updated if you want)

So need a little more context to help you find the best solution for your situation.

Lee Shastid OP  @Reply  
    
8 hours ago
Thank you both for your response. I think Raymond's option may work but I tried just not doing something correct. Donald your first sentence explains exactly what I want to do. The form I am working in is not a subform it is a stand alone form that feeds the continuous form that is a stand alone also.
Donald Blackwell  @Reply  
       
7 hours ago
Then as Raymond said, it's as simple as placing the requery in the After Update of the entry form:

Private Sub Form_AfterUpdate()
     Forms!MyContinousForm.Requery
End Sub


Just Replace "MyContinuousForm" with the name of your form. Or, if the form name has spaces or other characters, you can do:

Forms("My Continuous Form").Requery
Lee Shastid OP  @Reply  
    
7 hours ago
Thank you I will give that a try. Thanks so much guys I appreciate it.
Lee Shastid OP  @Reply  
    
6 hours ago
Donald I tried both of those strings and it does not update the continuous form until I close it and re open it. I tried it on the entry form and continuous form
Lee Shastid OP  @Reply  
    
6 hours ago
I figured it out, thank you very much. I did something wrong. I appreciate your help and patience.
Add a Reply Upload an Image
Next Unseen

 
 
What's This?

 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2026 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 9/25/2026 4:23:33 AM. PLT: 1s