Right Click Delete in List Box

[Dannyboy11]

On a form I have a list box that is populated from a query. Is there anyway that I can make it so you can right click one of the results in the list box and then delete it?

I have a list box on a user profile that shows a list of future events that they are attending. If I want them to no longer be attending one, the easiest way would be to right click it and then delete. Is this possible?

Thanks

 

[DCrake]

You would have to create a custom popup menu to do that and have a macro to delete the record based on the selection made in the list box.

Other than that you could place a delete button next to the list box and let the user click on the button.

 

[gemma-the-husky]

what you have to do in truth is delete the record form the underlying table that drives the list box, and then requery the list box

now - deleting data is a tricky subject, as it depends what the data is. often it is better to have a "completed" flag in the table - and just include a query that picks the not completed items - that way you don't actually delete data permanently - as this may affect historical analysis.

just something else to consider.