List Box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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"));
 
Hi,
Well, to refer to a list box in a query, you use this syntax:
Forms!yourFormName!yourListBoxName

--
HTH
Dan Artuso, Access MVP


Mark said:
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
Click to expand...
the double click. The where clause is what I need help on. How do I address the something in a List Box?
 
Back
Top