Refresh data on form after returning from a related form

[onechriswhite]

Using Access 10 on Windows 7, and getting very frustrated!
I have a form which displays data from a couple of queries This data is related to student test marks. On this form is also a command button which takes you to another form where you need to change some data, i.e. change some test marks.

On closing this second form and returning to the first, the data from the queries doesn't refresh. If I manually click "Refresh" at the top, then the data refreshes and all is fine.

I want some code or a macro that will trigger a refresh at the right time (as the second form is closing will be ideal). I have tried all sorts of refresh and requery commands but to no avail. Please help!

[ranman256]

In the 2nd form, when you click the SAVE button, it will
save the data
refresh the 1st main form by calling its refresh event: forms!frmMain.requery
close the form (form 2)

now you are back on the main form refreshed.
you can also make PUBLIC sub in the form to call from other forms.

form 1:

public sub RefreshMyData()
  me.requery 
end Sub

form 2:
forms!frmMain.RefreshMyData

[onechriswhite]

Great, thanks. Calling a main form requery on the second form's close action solved the problem