delete item from listbox query 1

[davyre]

Hi,
I got this delete query

DelQuery = "DELETE TblOrderUnit.* FROM TblOrderUnit WHERE OrderUnitID=TblOrderUnit.OrderunitID"

but it seems that the query is not working. What Im trying to do is to delete selected unit in the listbox, and delete the record from the table TblOrderUnit that has the same
OrderUnitID. It is so simple but I cannot figure the correct query. Anyone help? Thanks!

 

[PHV]

A starting point:
DelQuery = "DELETE * FROM TblOrderUnit WHERE OrderUnitID=" & Me![name of listbox].Value

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[TheAceMan1]

How are ya davyre . . .

If the listbox is on an open form don't forget to requery:

[blue]Me![ListboxName].RowSource = Me![ListboxName].RowSource[/blue]

See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[davyre]

thanks both of you! saved my day