Turning off a Confirmation Box

[Carrion]

I am changing a record with the following code:

DoCmd.RunSQL "UPDATE tblContact SET fax='" & Me!Fax & "' WHERE ContactID=" & Me!ContactInfo

A confirmatin message box pops up every time, is there a way in VB to prevent this message box?

 

[PHV]

Have a look at the DoCmd.SetWarnings method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Carrion]

Awesome Awesome Awesome.

That is exactly what i needed
Thanks