Recent content by DataAmatuer

This was an much, much more helpful direction than the one provided by Microsoft (almost always too technical and too vague to be of any help) at https://docs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/out-of-stack-space-error-28. Thank you, Mark K. You helped me find...

Let me follow up on this problem about the combo box that sometimes would stay open after opening the form, and other times not stay open. I had about decided that my form had a split personality disorder. But, alas, it now appears that the problem was a loose nut between the chair and the...

Yes. I did try that. In fact that's the way I first had it when it started leaving the combo box opened only briefly. There's more that I have discovered about this problem that is related to the code in the AfterUpdate event, but I'm out of time for now. Maybe I can tell you more about this...

You are correct, I did say yesterday that the DoEvents line made the combo box stay open when the form loaded. And it did . . . for a while. But then later the combo box resumed this strange behavior on only staying open a few moments after the form opened then closing (without me having...

I did not know that about SendKeys. Thank you for alerting me. But, as Uncle Gizmo posted a little while ago, the On Timer event is also reputed to cause problems. In my case, when I put the combo box ".Dropdown" command in a timer event, the box WOULD dropdown, but then close after just a few...

It turned out that the combo box would STILL close sometimes even when I commented-out the On Timer event and had the On Load event call the Public Sub Dropdown(), which used the ".Dropdown" command. Since discovering that there were still inexplicable cases of the combo box not staying open, I...

For most situations, I think you are right that it would be an annoyance to have the combo box dropdown on form load. But in this case, the combo box is on a form (named “frmInsCoAddEdit”) that is used for only one of two purposes: (1) to add a new insurance company name to a table of names, or...

Thank you, isladog, for explaining why the On Timer event is needed here. (And my apologies for tardiness in responding. Yesterday, shortly after posting the question about why the On Timer event was needed, I had to go offline and am just now getting back on.) Your explanation, along with a...

One more question about this: I would have never thought of using the On Timer event to solve this problem. Can anyone explain why this event must be used instead of the On Load (or On Open) event?

Thank you very much. It now seems to work as desired. It was the "DoEvents" line after the ".SetFocus" line that made it work. Just in case someone else is struggling with this in the future, here's how I have it set up now: 1. In the On Timer event procedure I have this code: Private Sub...

Thank you. I did as you suggested, but now the combo box only stays open momentarily. Is there any way that I can get it to open when the form loads, and stay open, but behave like it does when I have clicked on it? In other words, permit me to tab or click out of it.

I did go to the On Timer event and selected [Event Procedure] and set the Timer Interval property to 1. This now DOES open the combo box, but I cannot tab or mouse click out of it??

How do I do that?

My form has a combo box name cboCkInsCo. I want the box to open (i.e., dropdown) when the form form loads. I have the following code in the On Load event: Me.cboCkInsCo.SetFocus Me.cboCkInsCo.Dropdown (I also have the dropdown line in the On Got Focus event.) But the combo box still...

Thanks to all of you who gave me a warm welcome! I did not know the word "covert" as a group of coots!