How to refresh listbox after delete a record

[uronmapu]

How to refresh listbox after delete a record



My file: http://www.mediafire.com/?gx52u7393g9ll95

After double click a record on listbox, will be open new form and click DELETE

Idon't want to show DELETE on lisbox after delete




Many thanks

[nhior]

in the design form...go to properties...select after update (..), put the code me.requery

[uronmapu]

It' fine but only processing when click to other record ...

Please advices

Many thanks

[RuralGuy]

What code do you have in the DoubleClick event of the ListBox?

[uronmapu]

Please see below

Private Sub lstItems_DblClick(Cancel As Integer)
DoCmd.OpenForm "frmContactDetail"
End Sub



Attached file: http://www.mediafire.com/?gx52u7393g9ll95

[RuralGuy]

Great! Change the code to:

Private Sub lstItems_DblClick(Cancel As Integer)
   DoCmd.OpenForm "frmContactDetail" , , , , , acDialog
   Me.lstItems.Requery
End Sub

[uronmapu]

or: close and open form again thanks

Private Sub Delete_Click()
CurrentDb.Execute "Delete * From tblNames Where RecordID = " & Me.RecordID


DoCmd.Close acForm, Me.Name
DoCmd.OpenForm "frmSearchExample"

End Sub

How to I can to create next record button in the frmSearchExample form

[RuralGuy]

If that is a new issue then please mark this thread as Solved and start a new thread.