View Full Version : button to delete records


kgcrowther
06-05-2001, 07:34 AM
I've created a form for updating a list of engineers. (This list is used on another form so that spelling of engineers names are always consistent.)

On the form there are two buttons. One for adding a new engineer and the other for deleting one. However, when the user deletes an engineer from the list I have to go through and locate all the records in which that engineer is included and delete them. It seems like Access should be able to do it, but I just a summer intern and don't know much about VB.

Any help is great.

[This message has been edited by kgcrowther (edited 06-05-2001).]

Rich
06-05-2001, 08:29 AM
You need to link your tables correctly and allow cascading deletes.

kgcrowther
06-05-2001, 08:46 AM
That's what I needed to know. Thank you!