I coded this version of a DELETE statement:
VB Code:
  1. strSQL = "DELETE Main.Month FROM Main WHERE Main.Month <> '" & mstrMonth & "';"
  2.     'DoCmd.RunSQL (strSQL)
instead of this query in the DB:
VB Code:
  1. DELETE Main.Month
  2. FROM Main
  3. WHERE (((Main.Month)<>[Which month are you working on?]));
Is the coded SQL correct? I'm suspicious of it, even though it returns the same results.