I have a subform embedded into a main form. This subform as a combobox that is populated at the time the subform is loaded. Strangely enough, the subform functions normally when the database and form first open. However, there are times that for no good reason, I get a:

"Run-time error 2467: The expression you entered refers to an object that is closed or doesn't exist."

But this is simply not true. The object does exist. It is not closed. The error occurs when I use the .ListCount property on the combobox to see how many items were loaded onto it. It's acting as though the combobox and everything in the subform don't exist, but they do. Is the subform loading too slowly to "register" that it has a combobox? Why does this error sometimes happen, but sometimes not?

I'm not catching any patterns. Have you had this happen?



Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

__________________
Greg Serrano
Michigan Dept. of Environmental Quality
Air Quality Division

Hi,

Did you ever had any luck with your issue? I am facing exactly the same problem and was wondering if you were able to find a solution? If yes, could you let me know?