Close form and use VBA to refresh another open form

[puforee]

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

 

[dhookom]

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

 

[misscrf]

Before you close the update form, in the vba, put this:

Forms.frmFormToUpdate.Form.Requery

If you are updating a subform, then this:

Forms.frmFormToUpdate.frmSubformToUpdate.Form.Requery

misscrf

It is never too late to become what you could have been ~ George Eliot