Hi Chris
Did you not see my reply to your previous post? Here it is again:
This is nasty, obsolete code that was probably generated by a wizard. The
acMenuVer70 refers to Access 7.0 (aka Access 95)!!
The code is attempting to save the current record on your form.
Instead, you should use:
Application.RunCommand acCmdSaveRecord
or, even simpler:
Me.Dirty = False
"acFormBar" is a system-defined constant that refers to the variation of the
menu bar that appears when a form is in normal view.
But, like I said, this is obsolete code. There is never a reason these days
to use DoMenuItem. It can always be replaced by less complex, more reliable
code.
--
Good Luck
Graham Mandeno [Access MVP]
Auckland, New Zealand
Chris said:
What the heck is a FormBar and where can I find it in access. I have a
DoCmd.DoMenuItem statement that is using the acFormBar as the Menu Item.
It
doesn't seem to be doing everything it should when it runs so I need to
make
some modifications.