setwarnings in macro? access 2007 1

[simon551]

I'm trying to 'SetWarnings' in a macro in Access 2007. I get the message "the text you entered is not an item in the list." I searched the help and there is an entry for turning off the warnings... is there a security feature I need to override? any ideas? I also tried the RunCode command in the macro and typed SetWarnings (WarningsOff) but nope!

 

[simon551]

nevermind. I figured it out. I clicked the options to show arguments in design view and then setwarnings was added to the item list. go figure.

 

[NWildblood]

Thanks, I had previously just wasted an hour tracking this down... !

"No-one got everything done by Friday except Robinson Crusoe...