Refresh List

C

ckrogers

I know this must be easy ... but I don't even know what to search for....
I have one form "List" which is used to select and open another form "Form".
Right now, I leave "List" open while "Form" is completed and then closed.
I'd like to refresh(?)/requery(?) before you go back to "List".
1. What EVENT do I use?
2. One which form?
3. What command?
Thanks for your help.
 
A

Allen Browne

Use the AfterUpdate and AfterDelConfirm events of the 2nd form to requery
the first one if it is still open:

Private Sub Form_AfterUpate()
If CurrentProject.AllForms("List").IsLoaded Then
Forms("List").Requery
End If
End Sub

Private Sub Form_BeforeDelConfirm(Cancel As Integer, Response As Integer)
If Response = acDeleteOk Then
Call Form_AfterUpate
End If
End Sub
 
C

ckrogers

That's perfect ... thank you, Allen!
Cindy

Allen Browne said:
Use the AfterUpdate and AfterDelConfirm events of the 2nd form to requery
the first one if it is still open:

Private Sub Form_AfterUpate()
If CurrentProject.AllForms("List").IsLoaded Then
Forms("List").Requery
End If
End Sub

Private Sub Form_BeforeDelConfirm(Cancel As Integer, Response As Integer)
If Response = acDeleteOk Then
Call Form_AfterUpate
End If
End Sub
Click to expand...
 
Top