Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 02-07-2007, 10:00 AM   #1
aldeb
Newly Registered User
 
Join Date: Dec 2004
Posts: 318
Thanks: 0
Thanked 0 Times in 0 Posts
aldeb is on a distinguished road
Refresh form A from Command Button on form B

I currently have a Command Button on Form A that opens Form B. You enter information on Form B and then click another Command Button named Close Form. This closed Form B and updates records into a Table of which Form A is attached. When I click the Close Form Button on Form B I would like for Form A to be Refreshed?? so the information that was added in Form B will not be present in the appropriate Dropdowns in Form A. Currently I have to close Form A & reopen it for the information to be available. Any ideas?

__________________
Shalom & Blessings!
aldeb is offline   Reply With Quote
Old 02-07-2007, 10:56 AM   #2
boblarson
Smeghead
 
boblarson's Avatar
 
Join Date: Jan 2001
Location: Oregon, USA
Posts: 32,068
Thanks: 97
Thanked 1,827 Times in 1,578 Posts
boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold
In the On Close Event you can use
Code:
Forms!YourActualFormANameHere.Requery
to make data that has been added/edited show up

or
Code:
Forms!YourActualFormANameHere.Refresh
if you are only refreshing the recordset for changes that have occurred to the existing Form A recordset (no additions).
__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
boblarson is offline   Reply With Quote
Old 02-07-2007, 11:02 AM   #3
aldeb
Newly Registered User
 
Join Date: Dec 2004
Posts: 318
Thanks: 0
Thanked 0 Times in 0 Posts
aldeb is on a distinguished road
Thanks for the help!

__________________
Shalom & Blessings!
aldeb is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
refresh main form scottappleford Forms 12 06-09-2010 04:34 AM
Refresh Pivot table In Form M4Merlin Forms 1 03-02-2010 01:42 AM
[SOLVED] REFRESH Combo boxes for records on continous form Pele Forms 7 12-28-2005 06:52 AM
Update / Refresh a Form Upon Entering Data in a Popup Box / Form aikiai Forms 1 05-24-2005 12:31 PM
Refresh form and combo box with new values WarHorse Forms 4 05-23-2004 07:18 PM




All times are GMT -8. The time now is 09:40 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