Search and Delete Record from Multiple Tables 1

[DTSjunkie]

I want to create a single delete button for my Access Form. I have three tables: Contacts, Questionnaire, and Tracking. When the user clicks the delete button I would like to permanently delete the entire record (knowing the subject ID that connects all three) from each of the three tables.

 

[Remou]

Have you considered Cascade Delete? Alternatively, build SQL statements in code and run them:
[tt]strSQL = "Delete * From tblTable Where ID=" & intID
DoCmd.Run strSQL[/tt]

 

[DTSjunkie]

Worked perfectly...One more thing

I use a VBA MSG box to confirm the delete at the beginning. Is there anyway to prevent access from asking the user to confirm the delete of the record from each table?

 

[Remou]

Yes. Use DoCmd.SetWarnings.

 

[DTSjunkie]

Thank you very much........both suggestions worked perfectly!

 

[Remou]

You are welcome.