View Full Version : "update not available"


fluidmind
07-07-2006, 01:13 AM
Hi Guys!

I get a strange error, when inserting the update-function into my code:

DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70

I have the same line like a million times on other parts of my code, but one time I get the error: "The update-command is currently not available" (translated from danish version of Access).

I think that is really strange. What does that error mean?? Anyone knows? How can I possibly fix this?

//JR

RuralGuy
07-08-2006, 06:38 AM
Here's a link so you can switch to the newer RunCommands.
Converting DoMenuItem to RunCommand (http://home.clara.net/tkwickenden/domenuitem.htm)
Your DoMenuItem converts to DoCmd.RunCommand acCmdRefresh which can also be accomplished with Me.Refresh. I guess I would have to ask why you need to refresh the recordset? It may need a Requery instead.