object invoked has disconnected (2000 – SP 3)

Topic

New Reply

I get this error when running the attached workbook.

Run-time error ‘-2147417848 (80010108)
Automation error
The object invoked has disconnected from its clients.

To see it,
Open the workbook,
Click on the Select button
In the Date box, enter a new fate,
Press the Tab key.

That should produce the error. I have done some searching, here and google and microsoft, but nothing seems to apply to my problem

Thanks for any help

Reply | Quote

Replies

You unload the userform in the On Click event procedure of the list box. This event fires (I don’t know why) after any of the other controls has been updated. It’s better to put a command button on the userform that unloads it, and to remove unload from the On Click event of the list box.

Reply | Quote

Thank you Hans,
That did it.

I did want the user to only have to click on the list entry desired to update every thing but this works.

Reply | Quote

Closing the form on a single click of a list box is not as user-friendly as it may seem:
– In Windows applications, users can enter information in any order they like, so you can’t be sure that the list box is the last control they visit.
– Reacting to a list box click makes it impossible to select an item by using the up/down arrow keys, and to correct a mistake.

Reply | Quote

Yes, I have found that out. Thanks… Now if I can find a way to have the OK button work when the user presses the return key without regard to what field the cursor is in….

Reply | Quote

Set the “Default” property of the OK button to True.

Reply | Quote

Thank you Legare,

I had overlooked that property. It works just right now…

Reply | Quote