Access 2010: ListBox (Forms 2.0) not working after Windows Update

After one of the updates attached was installed the following VBA-Code line causes an error on Windows 7 using Access 2010:

Me.lbCountries.AddItem rst("Country")

lbCountries is a  ListBox (Forms 2.0) using

  • class: Forms.ListBox.1
  • OLE: Microsoft Forms 2.0
  • MultiSelect: Multi
  • ListStyle: Option

The code is still working using Win8 (x64) and Access 2013. On Win7 (x32) and Access 2010 the following error is displayed: Object doesn't support this property or method (Error Code 438)

After manual deinstallation of the mentioned updates the VBA-code executes as expected. ListBox seems to be unusable after one of the updates. All other workarounds trying to fill the ListBox cause the same error.

Fast Help is very appreciated.

April 1st, 2015 11:04am

Hi,

Would you please to tell us which KB caused this issue? As far as I know, after installing MS14-082 (part of December 2014 Public Updates for Office) you might get the error run-time error '438': Object doesn't support this property or method, when clicking on the enable content button.

If you have installed MS14-082, please try to install the hotfixs that released in the March 2015:

http://blogs.technet.com/b/the_microsoft_excel_support_team_blog/archive/2014/12/13/forms-controls-stop-working-after-december-2014-updates-.aspx

Hope it's helpful.

Regards,

George Zhao
TechNet Community Support

Free Windows Admin Tool Kit Click here and download it now
April 2nd, 2015 10:51pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics