Refresh form A from Command Button on form B (1 Viewer)

aldeb

Registered User.
Local time
Today, 16:47
Joined
Dec 23, 2004
Messages
318
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?
 

boblarson

Smeghead
Local time
Today, 13:47
Joined
Jan 12, 2001
Messages
32,059
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).
 

aldeb

Registered User.
Local time
Today, 16:47
Joined
Dec 23, 2004
Messages
318
Thanks for the help!
 

Users who are viewing this thread

Top Bottom