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,851
Thanks: 0
Thanked 449 Times in 445 Posts
June7 will become famous soon enough June7 will become famous soon enough
Re: Multiple Form Requery

I expect will have to explicitly Requery each form.
Attach File Manager is below Advanced editor window, click Go Advanced below Quick Reply window. To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
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 06:42 PM.

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