I'm trying to use a list box 'on_click' event to select a record to delete from the recordset that populates the list box.<br>
<br>
Have used Rst.Edit to set up the recordset for changes, Rst.Index to set field to look at, then Rst.Seek to locate the record that matches the ListBox.BoundColumn value, then Rst.Delete and Rst.Update. Then I Requery the list box so that it no longer displays the record that was just (supposedly) deleted.<br>
<br>
Seems like that should work, shouldn't it?<br>
<br>
What am I missing (besides a few marbles)?
<br>
Have used Rst.Edit to set up the recordset for changes, Rst.Index to set field to look at, then Rst.Seek to locate the record that matches the ListBox.BoundColumn value, then Rst.Delete and Rst.Update. Then I Requery the list box so that it no longer displays the record that was just (supposedly) deleted.<br>
<br>
Seems like that should work, shouldn't it?<br>
<br>
What am I missing (besides a few marbles)?