Go Back   Access World Forums > Microsoft Access Discussion > Macros

Thread Tools Rate Thread Display Modes
Old 12-10-2018, 07:20 PM   #1
Newly Registered User
Join Date: Oct 2018
Location: Australia
Posts: 16
Thanks: 12
Thanked 0 Times in 0 Posts
Hek is on a distinguished road
Post Multiple Form Requery

Hi all,

I'm a bit lost with this.
What I'm trying to achieve is that when I click a button it requery's the current form Im on and also another form in the database, which is also open.
This is because a SetValue macro is also activate on the same button, so what i want to happen is that value updates instantly on the other form.
Any help would be greatly appreciated.

Regards- Hek

Edit: not limited to macros, if easier will do it in VBA

Last edited by Hek; 12-10-2018 at 08:43 PM.
Hek is offline   Reply With Quote
Old 12-10-2018, 08:03 PM   #2
Newly Registered User
June7's Avatar
Join Date: Mar 2014
Posts: 1,388
Thanks: 0
Thanked 337 Times in 337 Posts
June7 will become famous soon enough
Re: Multiple Form Requery

I expect will have to explicitly Requery each form.
To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression. Attachment Manager is below Advanced editor window, click Go Advanced below Quick Reply window.
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
June7 is offline   Reply With Quote
The Following User Says Thank You to June7 For This Useful Post:
Hek (12-10-2018)

forms , macro , multiple

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Requery Multiple combo boxes? rc-alex Forms 1 05-29-2011 07:35 PM
Requery Multiple Forms after exiting a form manix Forms 2 12-21-2007 02:49 AM
Troubleshooting me.requery for multiple subforms. selvsagt Forms 2 07-11-2007 02:16 AM
requery multiple forms ???? accesscomthomas Forms 3 09-20-2004 02:18 AM
requery multiple forms on a page triple6 Forms 5 08-01-2003 09:17 PM

All times are GMT -8. The time now is 07:16 AM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post

Sponsored Links

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World