Update confermation

[Xavier]

I was wondering if there was a way when updating a table
threw a form to avoid the validation screen that asks you
if you are sure that you want to add this value. If
anyone could help I would be gratly apreaciative.

 

[Kevin]

Xavier,

Are you trying to add a record uising an append query or
an update query? if so, before you execute the query, use:

Docmd.SetWarnings False

Make sure when you have executed the query you follow that
with Docmd.SetWarnings True

Hope this helps!

Kevin

-----Original Message-----
Hi Xavier,

This is not a normal prompt - you must have some code in the BeforeUpdate
event of the form that is doing the prompting. Check it out and post back
with the event code if you still need help figuring it out.

--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this newsgroup.

I was wondering if there was a way when updating a table
threw a form to avoid the validation screen that asks you
if you are sure that you want to add this value. If
anyone could help I would be gratly apreaciative.

.