Argument not Optional - Error

[halem2]

Hi All

I'm getting an "Argument not optional" error on this piece of code. The qry itself is a make table qry and I need to bypass the prompts.

Any ideas why? thanks

DoCmd.SetWarnings = False
DoCmd.OpenQuery "qryJobInfoMkTblSpectrum", acNormal, acEdit
DoCmd.Close acQuery, "qryJobInfoMkTblSpectrum"

 

[boblarson]

It's just

DoCmd.SetWarnings False

(no = required)

 

[halem2]

I AM going to kick myself in the behind...

thanks Bob, as usual