Removing Access Delete Confirmation

[kermit5]

I currently have the following code that removes a record from a list of fields:

DoCmd.RunSQL "DELETE FROM tblSelectedFields " _
& " WHERE [SelectedField]= '" & Me![lstSelectedFields] & "'AND [MasterProjectID]= [cmbProject]"

When I click on the button that runs this code, I get Accesses default delete record confirmation. How can I disable this procedure for this code only?

Scott

 

[scottfarcus]

docmd.setwarnings(false)

DoCmd.RunSQL "DELETE FROM tblSelectedFields " _
& " WHERE [SelectedField]= '" & Me![lstSelectedFields] & "'AND [MasterProjectID]= [cmbProject]"

docmd.setwarnings(true)

 

[kermit5]

Thanks!