VBA help needed to delete ListBox selected record from table
Hi Gurus...
I have a table called "tblMaster", a query called "Add to dictionary" and a listbox called lstDelete. The query is created from tblMaster and the listbox row source is "qryMaster". Now I want a code to delete record from tblMaster based on lstDelete selection. Please help me with a code to do the same.
Thanks,
Joshi
Cheers,
Joshi
Being with a winner makes you a winner
Where is the list box? In a form? This will be easier to provide you a solution if you upload a sample of your db. Make sure that there are a representative sample of records. Do not upload the entire db as it will be to big. Make sure that after you sanitize the db and before uploading, you run a compact and repair to make it as small as possible. Next put it in a zip file as this forum does not accept accdb or mdb files to upload.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
I have done something similar, but it would depend on how your form is created. I have a staff listing, that manages various data.
You could make a subform that brings up the record that you selected from the listbox. you can then have a delete record button (or code an action) in the subform.
The other way I see of doing this is that you can bring up the table (in VBA for double click action of the listbox), and do a search delete of the record.
This code sample is of the former:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks