Listbox

[KatiS]

Hi

I am new to Access. I am trying to create a form which has a listbox related to my table and 2 buttons. One to add a new item to list box(Add new record) and one to remove.

The code for remove is this
Private Sub List0_Click()


Dim SelectCost As String
Dim RNo As Integer

TempVars("SelectCost").Value = Me!List0.ItemData(Me!List0.ListIndex)
End Sub
Private Sub Remove_Cost_ID_Click()
Dim strQuery As String
Dim IDToDelete As String

IDToDelete = TempVars("SelectCost").Value
If IDToDelete <> "" Then
strQery = " delete dbo.cost_centres where cost_id = '" & IDToDelete & "' "
DoCmd.RunSQL strQery
End If

End Sub


But it does not work. I get error message that the operand is missing.

Would you please help me?

Thank you

[amrut]

You need to mention the source from where you are deleting.
like DELETE FROM yourTableName

See http://www.techonthenet.com/sql/delete.php

[KatiS]

Thank you . the delete command was working in SQL but not in Access!!

I need one more help.

The event deletes the record now but my list box still shows the item. How can I refresh it ?

Thank you

[amrut]

Me.ListBoxName.Requery

[drexasaurus]

List0.Requery is the command. I find it helpful to review the API for objects I use frequently. I searched "listbox msdn access" and found this link: http://msdn.microsoft.com/en-us/libr.../ff195480.aspx.

[KatiS]

Thank you all

My form is working now

[amrut]

Glad to help. Mark the thread as solved.