I run the first part below (using EmailTableMaintFrm) to ask for the email address to be deleted. The user enter an email into "Me.EmailToDeleteFld
I have this code in my program (EmailTableMaintFrm)
Me.EmailToDeleteFld = InputBox("Please enter the Email to be deleted ", "Email Deletion")
'----- Clients
DoCmd.SetWarnings False
DoCmd.OpenQuery "DeleteStandardCEmailQry"
DoCmd.SetWarnings True
My query is DeleteStandardCEmailQry below
DELETE ClientEmails.ClientId, *
FROM ClientEmails
WHERE ClientEmails.EmailAddress =[EmailTableMaintFrm].[EmailToDeleteFld];
Obviously this something very simple because the code is not complex.
Any help would be appreciated
I have this code in my program (EmailTableMaintFrm)
Me.EmailToDeleteFld = InputBox("Please enter the Email to be deleted ", "Email Deletion")
'----- Clients
DoCmd.SetWarnings False
DoCmd.OpenQuery "DeleteStandardCEmailQry"
DoCmd.SetWarnings True
My query is DeleteStandardCEmailQry below
DELETE ClientEmails.ClientId, *
FROM ClientEmails
WHERE ClientEmails.EmailAddress =[EmailTableMaintFrm].[EmailToDeleteFld];
Obviously this something very simple because the code is not complex.
Any help would be appreciated