VBA: combobox not defined?

[opopanax666]

Hi everybody,



made an unbound form with one combobox used to filter another. Everything worked great until I used "Option explicit" in the code. I get this error:



What it says is that the AfterUpdate gives a Variable Not Defined error.

Here's the AfterUpdate code:

Private Sub cboHoofd_AfterUpdate()

  Me.cboSub1 = Null
  Me.cboSub1.Requery
  Me.cboSub1 = Me.cboSub1.ItemData(0)

End Sub

Can someone please spot the error?

[boblarson]

Are you ABSOLUTELY sure that your combo is named cboSub1?

Also, your database might need to run a DECOMPILE which can resync up the VBA which can sometimes get off (make sure to make a backup copy BEFORE doing the decompile).

[opopanax666]

Are you ABSOLUTELY sure that your combo is named cboSub1?

Yes, as I said it all worked fine before the "Option Explicit".

Also, your database might need to run a DECOMPILE which can resync up the VBA which can sometimes get off (make sure to make a backup copy BEFORE doing the decompile).

The problem is that I have access to Access () through a Citrix client, and I have no clue what the path to the Access.exe is to run the decompile commandline...

[boblarson]

The problem is that I have access to Access () through a Citrix client, and I have no clue what the path to the Access.exe is to run the decompile commandline...

Can you not download the Access file to your desktop? We run Citrix and I am responsible for our Access databases and I can download it to my desktop. But I don't have to because I have access to the Citrix desktop. You may need to get some IT folk involved to let them know you need to be able to do this, even if it is just a one time shot. Someone needs to be able to do things with the file. Is this a split database? If not, it really needs to be and each user should be getting a copy of the frontend loaded to a temp directory that Citrix makes when they log in.

Where I work we run a batch file which copies the frontend into a temp directory on the Citrix machine so that each user has their own copy otherwise it can cause major problems and corruption.