You beat me to replying. I figured it out. A little bit of sniffing around on MSDn can prove useful.
For future refference, here is what I did (for anyone who has the same question as I did)
Dim msg As String
Dim result As VbMsgBoxResult
msg = "You Are About to delete the user: " & txtUserName.Value & " from the system permenantly. Are you sure you want to do this? NOTE: this Operation CANNOT be undone!"
result = MsgBox(msg, VbMsgBoxStyle.vbYesNoCancel, "Are you Sure?")
If (result = vbYes) Then 'if and only if the user clicks on Yes
DoCmd.RunSQL (Users_del) 'perform the deletion from the uses table
DoCmd.RunSQL (Intersection_del) 'perform the deletion from the Intersection table
ElseIf (result = vbNo) Then 'if the user decided to not delete
msg = "Deletion of User: " & txtUserName.Value & " Has Been Aborted!"
Else 'the user clicked cancel
msg = "Deletion of User: " & txtUserName.Value & " Has Been Cancelled!"
NOTE: [i]I plan on releasing the MDB file (with the VBA source code) when i am done as Open Source. I realize such a program can be useful to others as they see my code