I have a good working Form button. However, I am asked 9 times to answer YES when 3 queries that are inside the button,
ask like, you are about to override, etc etc. A dialog thing. The 3 queries create 3 make tables.
I will always answer yes.
Is there a way to permanently lock in the YES for these 3 queries?
I read something about Set Warnings. I wonder.
Here is the button ON Click. Thanks Glen.
Private Sub cmd3010M_Click()
'MAKE TABLES
DoCmd.OpenQuery "Qry3010B", acNormal, acEdit
DoCmd.OpenQuery "Qry3010C", acNormal, acEdit
DoCmd.OpenQuery "Qry3010E", acNormal, acEdit
'MAKE REPORT - IN
DoCmd.OpenReport "rpt3010M", acViewPreview
DoCmd.Maximize
End Sub
ask like, you are about to override, etc etc. A dialog thing. The 3 queries create 3 make tables.
I will always answer yes.
Is there a way to permanently lock in the YES for these 3 queries?
I read something about Set Warnings. I wonder.
Here is the button ON Click. Thanks Glen.
Private Sub cmd3010M_Click()
'MAKE TABLES
DoCmd.OpenQuery "Qry3010B", acNormal, acEdit
DoCmd.OpenQuery "Qry3010C", acNormal, acEdit
DoCmd.OpenQuery "Qry3010E", acNormal, acEdit
'MAKE REPORT - IN
DoCmd.OpenReport "rpt3010M", acViewPreview
DoCmd.Maximize
End Sub