Go Back   Access World Forums > Microsoft Access Discussion > Macros

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 12-10-2018, 07:20 PM   #1
Hek
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
June7
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.
DEBUG! DEBUG! DEBUG!
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)
Reply

Tags
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
General
Tables
Queries
Forms
Reports
Macros
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