Access 2007 : Error 2950 appears only in ACCDE

0
votes

I have a database with all macros running fine when the file is an accdb format , when i make the accde a message appears saying command or action "refresh" is not available now , and then when i press ok it gives an error 2950 . Please notice that i run the database from a trusted location.

Thanks, Bishoy

1
ms-accessms-access-2007
By the Way , i just discovered that this only happens if i execute an open form macro action before i run this command , the other refresh buttons work fine in the Accde. – Bashawy

1 Answers

1
votes

I suspect that this is because the form does not have focus. You could try setting the focus to the relevant form after the open macro and before refresh.

Forms("Form1").SetFocus