default access messages on query run

[definewebsites]

Hi there,

I have an access database in which I am updating a table from a form using visual basic for access. I have got the update to work, however before the application appends the table, it asks a question "You are about to append a row" then an option for "yes or no"

I have a custom message that appears after the appending, but I do not want the message in bold above to appear at all. Does anyone know how I can suppress that message?

Thanks

 

[pbaldy]

You can use CurrentDb.Execute instead of DoCmd.RunSQL.

 

[definewebsites]

Thanks

Thanks alot for the tip, I will give it a shot and feedback on what happens..

Cheers

 

[definewebsites]

Thank you for your assistance. I used your suggestion in conjunction with dbFailOnError and it worked.
I do appreciate

Cheers

 

[pbaldy]

No problem; glad we got it sorted out.