Refresh a form when closing another form

[dsc2bjn]

I apologize if this is posted somewhere already, I looked and didn't see
anything that exactly matched.

I have created a form which serves as a record selection screen to allow a
user to edit certain values.

Once the user highlights a particular row, they click on a "Edit Record"
button. This takes them to a second form which allows them to edit certain
data fields.

When the user has made the changes, they click on a "Save & Close" button
which returns them to the record selection form.

I wish to refresh the record selection form, when the "edit record" form
closes.

 

[Roger Carlson]

Try adding:

Private Sub Form_Close()
Forms!MainForm.Requery
End Sub

in the Form Close Event of the edit record form. Replace your actual form
name for "MainForm".

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L