I have a form that has a button to add a comment. If you click the button it pops up another form in front of the original form to allow the user to add a comment for that user. Once you add the comment and close the record, I’d like the original form to refresh to display the new comment. Is that possible?
![]() |
Patch reliability is unclear, but widespread attacks make patching prudent. Go ahead and patch, but watch out for potential problems. |
SIGN IN | Not a member? | REGISTER | PLUS MEMBERSHIP |
-
form refresh (2003)
Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » form refresh (2003)
- This topic has 7 replies, 4 voices, and was last updated 18 years, 2 months ago.
Viewing 1 reply threadAuthorReplies-
WSHansV
AskWoody Lounger -
WSDouglas Martin
AskWoody LoungerFebruary 9, 2006 at 5:10 pm #999263If you need to do something after the popped up form closes (whether that be refreshing if for some reason it’s necessary, or anything else), make the popped up form modal. Execution then won’t continue in the underlying form until the modal form closes or is made invisible, and you can then do me.refresh or whatever else is necessary.
-
WSmuscle
AskWoody Lounger -
WSDouglas Martin
AskWoody LoungerFebruary 9, 2006 at 6:31 pm #999272When you are writing VBA code for a form or report, me is used to point to the form or report that your code is running in. Quoting from the help, “The Refresh method immediately updates the records in the underlying record source for a specified form or datasheet to reflect changes made to the data by you and other users in a multiuser environment.”. Hence me.refresh runs the refresh method for the form your code is running in. See also repaint and requery.
-
WSHansV
AskWoody LoungerFebruary 9, 2006 at 6:32 pm #999273Make the code that opens the other form look like this (the actual names will be different, of course)
Private Sub cmdOtherForm_Click()
On Error GoTo Err_cmdOtherForm_ClickDim stDocName As String
Dim stLinkCriteria As StringstDocName = …
stWhereCondition = …DoCmd.OpenForm stDocName, , , stLinkCriteria, , acDialog
Me.RefreshExit_cmdOtherForm_Click:
Exit SubErr_cmdOtherForm_Click:
MsgBox Err.Description
Resume Exit_cmdOtherForm_Click
End Sub -
WSjaf90
AskWoody Lounger
-
-
-
Viewing 1 reply thread -

Plus Membership
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
Get Plus!
Welcome to our unique respite from the madness.
It's easy to post questions about Windows 11, Windows 10, Win8.1, Win7, Surface, Office, or browse through our Forums. Post anonymously or register for greater privileges. Keep it civil, please: Decorous Lounge rules strictly enforced. Questions? Contact Customer Support.
Search Newsletters
Search Forums
View the Forum
Search for Topics
Recent Topics
-
Are manuals extinct?
by
Susan Bradley
1 hour, 3 minutes ago -
Canonical ditching Sudo for Rust Sudo -rs starting with Ubuntu
by
Alex5723
4 hours, 12 minutes ago -
Network Issue
by
Casey H
10 hours, 44 minutes ago -
Fedora Linux is now an official WSL distro
by
Alex5723
16 hours, 11 minutes ago -
May 2025 Office non-Security updates
by
PKCano
16 hours, 38 minutes ago -
Windows 10 filehistory including onedrive folder
by
Steve Bondy
18 hours, 33 minutes ago -
pages print on restart (Win 11 23H2)
by
cyraxote
17 hours, 49 minutes ago -
Windows 11 Insider Preview build 26200.5581 released to DEV
by
joep517
20 hours, 45 minutes ago -
Windows 11 Insider Preview build 26120.3950 (24H2) released to BETA
by
joep517
20 hours, 46 minutes ago -
Proton to drop prices after ruling against “Apple tax”
by
Cybertooth
1 day, 4 hours ago -
24H2 Installer – don’t see Option for non destructive install
by
JP
12 hours, 30 minutes ago -
Asking Again here (New User and Fast change only backups)
by
thymej
1 day, 15 hours ago -
How much I spent on the Mac mini
by
Will Fastie
14 hours, 53 minutes ago -
How to get rid of Copilot in Microsoft 365
by
Lance Whitney
10 hours, 4 minutes ago -
Spring cleanup — 2025
by
Deanna McElveen
1 day, 21 hours ago -
Setting up Windows 11
by
Susan Bradley
16 hours, 24 minutes ago -
VLC Introduces Cutting-Edge AI Subtitling and Translation Capabilities
by
Alex5723
1 day, 16 hours ago -
Powershell version?
by
CWBillow
1 day, 17 hours ago -
SendTom Toys
by
CWBillow
4 hours, 32 minutes ago -
Add shortcut to taskbar?
by
CWBillow
1 day, 21 hours ago -
Sycophancy in GPT-4o: What happened
by
Alex5723
2 days, 13 hours ago -
How can I install Skype on Windows 7?
by
Help
2 days, 12 hours ago -
Logitech MK850 Keyboard issues
by
Rush2112
1 day, 19 hours ago -
We live in a simulation
by
Alex5723
3 days, 4 hours ago -
Netplwiz not working
by
RetiredGeek
2 days, 14 hours ago -
Windows 11 24H2 is broadly available
by
Alex5723
3 days, 16 hours ago -
Microsoft is killing Authenticator
by
Alex5723
18 hours, 24 minutes ago -
Downloads folder location
by
CWBillow
3 days, 23 hours ago -
Remove a User from Login screen
by
CWBillow
2 days, 18 hours ago -
TikTok fined €530 million for sending European user data to China
by
Nibbled To Death By Ducks
3 days, 14 hours ago
Recent blog posts
Key Links
Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.
Mastodon profile for DefConPatch
Mastodon profile for AskWoody
Home • About • FAQ • Posts & Privacy • Forums • My Account
Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts
Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.