Strange error: "Update not available"???

[fluidmind]

Hi Guys!

I want to insert an update-button in my form (see attachment). When i use the Access-guide it inserts the following line into the buttons onClick-code:

DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70

But then I get this strange 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

 

[Banana]

Firstly, the code wizard use is obsolete. I don't the code for updates, but it'd be something like

DoCmd.RunCommand acCmd....

Maybe even this will work for you, but I am not 100% sure because I haven't seen how your form works and exactly why you need it to be updated,

Me.Refresh

As to the error itself, I want to make sure- are you using a popup and modal form? That will not allow the RunCommand to run.

If not, it usually is because you're trying to do something that would be problematic at this point. A good example would be trying to save record in BeforeUpdate event; that will cause infinite loop because BeforeUpdate event occur before saving, but it's saying to save, so before update fires again and so ad infinitium.

 

[fluidmind]

Thanks for helping

Thank you so much. I will try to implement it in my system on monday... And then we'll see if it works!

Have a nice weekend!

// JR