One box, many uses.

[Accessable]

In a tabular subform, I have a combo box that shows for each record. This combo box performs several operations.

On Not In List, it opens a form to add a new list item.

On Current, It sets the Picture property of an Image control on my main form equal to a path chosen from the combo box.

On Dbl Click, It should open a new form using data specific to the chosen record.


The problem I'm running into is that the On Current event is still working when the Dbl Click event starts (because all the user has to do to start the On Current event is to click one of the combo boxes of a record of the subform).

Somehow it is confusing Access, and it just closes everything with absolutely no warning.
Any help?

 

[John.Woody]

Your problem may lie in the fact that every time you click the box you're restarting the On Current code. Try moving the on current code off the combo box and put it On Current for the form. See if your double click code works, if it does work out where to put your code which is in On Current if that does not work satisfactorily.