Delete button coding

[nub65]

I am a student and i am familiar with vb but not familar at all with vba i have picked up a couple books but nothing in these books seem to work with this problem. I have a form with a list box that pulls data from a table i want to create a button that will delete the selected item in the list box and all the records related to this item as per the the key row. Can some one give me some guidance on this thank you in advance scott

[JKing]

Hi there. We have fairly strict rules as per dealing with homework questions for students. Guidelines Though I won't give you the code I will try to explain the logic.

The gist of what you want to do is on the click event run a delete query that will remove all records in the table where the key is equal to the key of the selected listbox item. Assuming your listbox is drawing it's source from the table or a query of this table simply requery the listbox to update and remove any deleted items.

Try attempting this and if you run into any errors we can help you debug your code but we cannot provide a full solution.

[nub65]

Ok thank you i want to elaborate a little more on the problem. I try to declare a variable as database or currentdatabase none of these commands are recognized neither is the command of sqldef

[JKing]

Sounds like you are missing a reference. In the VBA editor check under Tools > References and make sure you have Microsoft DAO Object library checked.

If that doesnt fix it, post the code you are having trouble with.