I would like to incorporate some data management to my database using a one button data delete option. In this database there are several ID's that can be assigned to one user. These ID's are then linked to several different tables. I would like some help creating a button on a form that, when pressed, will delete the user's name and delete all associated (linking) ID's from all other tables.<br><br>Thanks.<br>Sam<br>
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Deleting data from several tables.
- Thread starter sacheson
- Start date
One way is to create a delete query with a criteria of forms!yourformname!yourcontrolname in the id column. Then use the button wizard, selecting Miscellaneous, then RunQuery. Choose one of the delete queries, then after you complete the button, fo back and alter the code to run the others afterwards.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question