Deleting a Record from the DBListBox

Deleting a Record from the DBListBox

Question:
How do I delete a record with the data I’ve selectedin a DBListBox (VB4.0). If I use the e.g. Findfirst command I get the message:

“The action was cancelled by an associated object.”
Would it be possible to use “SelectedItem” or “Bookmark”. If, then how?

Answer:
Since the DBListBox is the data source for the list, you can look at the Data.Recordset property, and use it like a Dynaset. For instance, if you wanted to delete the record from your box that had the word “Lego” from a field named “Name”, you could do the following:

Data.Recordset.FindFirst “Name = ‘Lego'”Data.Recordset.Delete
That should work without any problems.

Share the Post:
data observability

Data Observability Explained

Data is the lifeblood of any successful business, as it is the driving force behind critical decision-making, insight generation, and strategic development. However, due to its intricate nature, ensuring the

Heading photo, Metadata.

What is Metadata?

What is metadata? Well, It’s an odd concept to wrap your head around. Metadata is essentially the secondary layer of data that tracks details about the “regular” data. The regular