suppress delete warning (access 2003)

[HansV]

You can insert

DoCmd.SetWarnings False

before running the delete query, and

DoCmd.SetWarnings True

after it.

[dieders]

Hi

Probably very simple but I can't find it...

Hope anyone can help me out with this.

I Have a delete query that deletes a couple records out of my table
I am using a button to run the macro: Docmd open query etc.
and now I am looking for some code to suppress the confusing error warning that access displayes.
I have created my own message box and then I just want it to happen without the extra access warning

(I know all delete warning messages can be turned off in the general access options but that is not what I want).

Thanks ahead.

Diederik

[dieders]

Thanks Hans.

works perfect!

Diederik