Listbox and SQL statement

J

Jay

How can I have it when someone clicks on a line in my
listbox a delete query will run to delete the row that is
highlighted.
 
D

Dan Artuso

Hi,
I'm going to have to make a few assumptions here.
Mainly that the bound column of your listbox is the primary key of the table that
is used to populate the box and the listbox IS NOT multi-select

Dim strSql As String

strSql = "Delete From yourTable Where id = " & Me.yourListbox
CurrentDb.Execute strSql

substitute the correct field name for 'id'

That should get you started.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to determine if the rows selected in a simple multi-selectlistbox have been changed? 2
Access 2003, how do I know if a listbox has no row selected? 2
Macro to select and delete levels of a document 2
ADDING values from one listbox to another on same form 1
Listbox Quandry 2
Submit form 0
Open form 0
Need Help with a VBA subroutine 0

Top