To display or not to display

[Trinb37]

Hi,
here is the thing. I have this Access program that I am working on that is suppose to delete the selected item in the list box when every I click the delete button. When the delete button is clicked the item in the list box on top would be deleted and not the one that is already selected. Is there anyone who can show me what I did or rewrite the code for me? This is the code that I was working with:

Private Sub cmdDelete_Click()
On Error GoTo Err_cmdDelete_Click
DoCmd.RunCommand acCmdDeleteRecord
Me.List0.Requery
Exit_cmdDelete_Click:
Exit Sub
Err_cmdDelete_Click:
MsgBox Err.Description
Resume Exit_cmdDelete_Click

End Sub

I also took the liberty of uploading the whole utility program so that you can take a closer look at it.

~~~~~~~~~~~~~~~~~
James

 

[RayH]

add this to your UP button code
DoCmd.GoToRecord , , acPrevious

and
DoCmd.GoToRecord , , acNext
to your DOWN button code.

The reason it always deleted the first record is that the ACTUAL record never moved and always stayed on the first record.

 

[Trinb37]

Thank you very much. You would not believe all the kinds of stories I heard from other people on how to fix this problem. But you came through for me and very greatful.

 

[Trinb37]

Thank you very much. You would not believe all the kinds of stories I heard from other people on how to fix this problem. But you came through for me and very greatful.

 

[Trinb37]

Thank you very much. You would not believe all the kinds of stories I heard from other people on how to fix this problem. But you came through for me and very greatful.