Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Close form and use VBA to refresh another open form

Status
Not open for further replies.

puforee

Technical User
Oct 6, 2006
741
US
From a form "Microsim Work Form" I open an update form. After completing the updates I will close the update form. On the close event of the update form I want to refresh the "Microsim Work Form". How would I do this with VBA in the Update form Close event? Also, is Refresh the best code to use? I want the "Microsim Work Form" to show the data that was updated. Or would Requery work better?

Thanks,

John
 
What have you tried? I would use requery if there is a chance that new records could be added.

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016
 
Before you close the update form, in the vba, put this:

Code:
Forms.frmFormToUpdate.Form.Requery

If you are updating a subform, then this:

Code:
Forms.frmFormToUpdate.frmSubformToUpdate.Form.Requery

misscrf

It is never too late to become what you could have been ~ George Eliot
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top