DoCmd.RunSQL (1 Viewer)

L4serK!LL

Registered User.
Local time
Today, 19:41
Joined
Jul 22, 2002
Messages
59
I've put a STOP button on my form that enables the user to exit the form; what the button does is delete the current record from the table and then close the form, and for that i use the DoCmd.RunSQL "Delete FROM table WHERE ID=" & Number

However the user is still prompted as to whether he's sure to delete 1 row from the database and this could be quite confusing on future users as they probably would press No... (n00bs :p )

How can I avoid that an extra confirmation is required?
 

yellow

Registered User.
Local time
Today, 19:41
Joined
May 16, 2002
Messages
122
Code:
docmd.setwarnings = false
Put your code in here
Code:
docmd.setwarnings = true
 

L4serK!LL

Registered User.
Local time
Today, 19:41
Joined
Jul 22, 2002
Messages
59
EXCELLENT! :D
Spank you man ;)
 

Users who are viewing this thread

Top Bottom