Listbox AfterUpdate event interfering with listbox DoubleClick event.

[Salty Mariner]

I have an interesting problem. I have a listbox in which I have an AfterUpdate event firing that changes the value of a textbox and a label caption property. After the listbox item is selected I want to run some code on a DoubleClick event of the listbox to open a folderbrowser save the path and write that path to a recordset. Allof this seems as though it should be pretty straight forward. The listbox DoubleClick event however won't fire unless I either click into empty space on the listbox or I disable the AfterUpdate Event.

Any idea of what might be going on here and possible workarounds? I would think that the two events should be entirely separate entities but apparently I am mistaken. I guess I could dispense with the DoubleClick and use a button if I had to but I'd rather try to figure this out.

[Salty Mariner]

Well I fixed my issue by breaking up one subroutine into 2 smaller ones. As I was building the code and adding more actions I had one subroutine that was accomplishing several different things and I thought I could fire them off all together (I was wrong). Breaking them up then firing and closing them separately seemed to solve whatever conflict issue I was having.

[Missinglinq]

The use of the ClickEvent for a Control prevents the use of the DoubleClick event...Access will only 'register,' if you will, the first click.

In order to have an AfterUpdate, the ClickEvent must have been fired for the Listbox Control, hence rending the DoubleClick event powerless.

Glad your work around solved your problem!

Linq ;0)>

[Salty Mariner]

The use of the ClickEvent for a Control prevents the use of the DoubleClick event...Access will only 'register,' if you will, the first click.

In order to have an AfterUpdate, the ClickEvent must have been fired for the Listbox Control, hence rending the DoubleClick event powerless.

Glad your work around solved your problem!

Linq ;0)>

Yeah I sort figured all of that out...the hard way. Oh well, it was a good learning experience that I won't forget.