delete from a list 1

[orionsong]

Can we delete an item from a list directly?

 

[DougP]

Well yeah.<br>Uh what kind of list?<br>A form <br>A Table<br>A Query<br>A report<br>A listbox on a form.<br><br> <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.

 

[orionsong]

Oops, sorry there. Can we delete from a listbox on a form directly without going into another form?

 

[JimConrad]

The ListBox itself does not provide any support for deleting data from the tables in it's RecordSource, but you can certainly write code yourself to do this.<br><br>Assuming a listbox called MyList, which displays the primary key (MyKey) from table MyTable and a button on the form named MyDelButton...<br><br><FONT FACE=monospace><br>Sub MyDelButton_Click()<br><br>&nbsp;&nbsp;&nbsp;&nbsp;DoCmd.RunSQL &quot;Delete From MyTable Where MyKey = &quot; & Me!MyList<br>&nbsp;&nbsp;&nbsp;&nbsp;<br>&nbsp;&nbsp;&nbsp;&nbsp;MyList.Requery<br><br>End Sub<br></font><br><br>If MyKey is a text field, change the code above to enclose Me!MyList in single quotes...<br><br>... Where MyKey = <font color=red><b>'</b></font>&quot; & Me!MyList & &quot;<font color=red><b>'</b></font>&quot; <br> <p>Jim Conrad<br><a href=mailto:jconrad3@visteon.com>jconrad3@visteon.com</a><br><a href= > </a><br>

 

[orionsong]

it is a listbox on a form

 

[orionsong]

thanx lots JimConrad.