Docmd.Menuitem in Access 2003 generates error

[Guest]

Hi - I have this code DoCmd.DoMenuItem acFormBar, acRecordsMenu, acRefresh
in the "on change" event of a text box - when it kicks in I get an error
message saying there is an invalid name for the menu, command, or subcommand.
I'm suspecting that Access 2003 doesn't suuport this code. Any help is much
appreciated.

 

[Stuart McCall]

Hi - I have this code DoCmd.DoMenuItem acFormBar, acRecordsMenu,
acRefresh
in the "on change" event of a text box - when it kicks in I get an error
message saying there is an invalid name for the menu, command, or
subcommand.
I'm suspecting that Access 2003 doesn't suuport this code. Any help is
much
appreciated.

Most (if not all) of that old DoMenuItem stuff can now be executed via the
RunCommand method of the DoCmd object.

DoCmd.RunCommand acCmdRefresh

ought to do it in this case. Unfortunately I'm unable to test at the
moment...