Button that runs a Delete Query

  • Thread starter Thread starter Carol
  • Start date Start date
C

Carol

I want to put a button on my form that will allow a Delete
Query to run, but when the list from which to choose a
query displays, the Delete Query isn't there. Does anyone
know of a rule that does not allow a Delete Query to be
assigned to a button?
 
Put the following code in the Click event of the button:
DoCmd.SetWarnings False
DoCmd.OpenQuery "MyDeleteQuery"
DoCmd.SetWarnings True
 
You are talking about the list that comes up in the command button query?
Have you designed a delete query? if so, it would be on that list...

Damon
 
Back
Top