List Box

[Mark]

I have a list box (LsOrd) on a form that has a double click event. I want to be able to delete the record that I select during the double click. The where clause is what I need help on. How do I address the something in a List Box?

DELETE tbOrdHold.qtyhld, tbOrdHold.itmhld, tbOrdHold.Jobnum
FROM tbOrdHold
WHERE (((tbOrdHold.itmhld)="LsOrd") AND ((tbOrdHold.Jobnum)="LsOrd"));

 

[Dan Artuso]

Hi,
Well, to refer to a list box in a query, you use this syntax:
Forms!yourFormName!yourListBoxName

--
HTH
Dan Artuso, Access MVP

I have a list box (LsOrd) on a form that has a double click event. I want to be able to delete the record that I select during

the double click. The where clause is what I need help on. How do I address the something in a List Box?