Refresh a differnent form on close

AWilderbeast

Registered User.
Local time
Today, 10:38
Joined
Sep 13, 2005
Messages
92
HI basically i have a form which dislays records in a continous list, then an add button which adds records to the list. to view the newly added records you have to close the form and open it again.

I have inserted a refresh button but what im after instead is when i close the 'add form' it refreshes the list form. Below is the code for the refresh button could someone tell me what i need to add/change to make it refresh a particular form on close?

Private Sub Command45_Click()
On Error GoTo Err_Command45_Click


DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70

Exit_Command45_Click:
Exit Sub

Err_Command45_Click:
MsgBox Err.Description
Resume Exit_Command45_Click

End Sub

Thanks for any help
 

Users who are viewing this thread

Back
Top Bottom