What is the best way to update 1 of 6 tabular forms after the data has been changed in another form?

[IamKJVonly]

I know I'm pushing my luck today with a

nother request but here goes:



I have a main menu form (which I will call form 1) from which I select 1 of 6 tabular forms.
II takes me to a tabular form which (I will call form 2) where I

select

the record I want to change.
Now I go to a form

(which I will call form 3)

where I can change any of the fields in the selected record and save the changes by closing form 3.
This drops me back to the original selected 1 of 6 tabular form 2 which is now needs to be updated.

This is my question: What's the best way to update form 2.
What I do now (if I remember to do it).
Is to close form 2 manually by clicking on the form's x.
This

drops me back to form 1 where I manually select form 2 again which then get updated.

I hoping there is and easier way to do this by updating form 2 when I drop back to it without having to go back to form 1 or do anything manually.
I've tried everything I know (which is NOT much) without direction and my almost non existent coding ability; I see nothing but problems ahead in this area.

So I can truly say any and all help will be greatly appreciated.
Dave.

[pbaldy]

You can refresh or requery form 2 from form 3's close event.

[ranman256]

forms!form2.requery

[IamKJVonly]

It was a good idea but didn't work.
It looks like you can only requry a field.

"There is no field named 'forms!frm_F_DateLastRead.requery' in the current record.

Is the Command I used: forms!frm_F_DateLastRead.requery

Dave

[pbaldy]

It would go in the VBA editor. Sounds like you put it in a macro.

http://www.baldyweb.com/FirstVBA.htm

[IamKJVonly]

Your right I just haven't been thinking in terms VBA DoCmd but I'm getting there. LOL

The following code works fine. Thanks for the help.
Private Sub cmdReturn_Click()
DoCmd.Close acForm, "frm_F_AddEditBookRecord"
DoCmd.Requery frm_F_DateLastRead
End Sub

I guess the old saying you have to crawl before you can walk certain fits me to a "T".
Thanks again I couldn't have done it without your help.
Dave

[pbaldy]

No problem Dave.