On the close event of a form , update listbox in the other form.

[AmanKaur123]

Hi Guys



I have a list box on form "frmMain" , when the user double click on any item in the list box then a form "frmCall" opens up with all its details. Now what I want is when they update the details on the form "frmCall" and come out of it (close frmCall) then command15_click event should be called. But at the moment when the 'frmcall' opens up then the event Command15_click event is called.

ANy help will be much appreciated.

Private Sub lstSupActivities_DblClick(Cancel As Integer)
Dim i As Integer
Dim sSQL As String
Dim sForm As String
For i = 0 To lstSupActivities.ListCount - 1
    If lstSupActivities.Selected(i) Then
       sForm = "frmCall"
       sSQL = "[AuditID]=" & Me.lstSupActivities.Column(1)
       DoCmd.OpenForm sForm
       DoCmd.OpenForm sForm, , , sSQL, , WindowMode:=acDialog
       Command15_Click
       ' DoCmd.OpenForm "frmCallAudit_New", , , sSQL
       Exit For
     End If
 Next i
End Sub

[aytee111]

Not sure where Command_15 comes into it, all you need is in the OnClose event to requery the listbox on the main form.

[AmanKaur123]

yES . GOT IT. THANKS