I have a function that selects list-box values based on the selection made from a corresponding combo-box. I call this procedure from each one of the combo-boxes that is setup to do this. I'm doing this from the "On Click" event. I have tried it from "On Enter" to but still cannot get it to work.

All I'm trying to do is have the combo-box keep the focus, so the user can continue typing names, hitting enter and the selections are highlighted. Below is the routine for this.
Private Sub MyLBSelections ()

End Sub
This is just being called like this from the combo-box's "On Click" like this.

MyLBSelections

I have tried tried setting the focus to the control from the control's "On Enter, On Click, and After Update" events with now success e.g. Me.MyControl.SetFocus

Something that should be so simple but yet has me perplexed. Any assistance would be appreciated.

(sorry if this is a duplicate ... I suffer from BFF syndrome -- big fat fingers)

Let's see if I understand ...

You have a combobox. You pick an item. That selected item "moves" to a listbox. You want the combobox to retain (?regain) the focus so more items can be "moved" to the listbox. (... and you have more than one of these pairs ...)

Right off the top, I'm wondering if having paired listboxes that let you pick items from the list of "availables" and move them to the list of "selecteds" would accomplish what you're after? I've not run into the combobox/listbox pair, and it seems like it might be a bit more work than the paired listboxes...

JOPO (just one person's opinion)

if you are using 2007 have you tried going into access options and setting the behavior there ?

Hi Jeff,

I know what you mean with the moving of items from one combo/list-box to another and how that can cause problems. That's not what I'm doing here. The entry in the list-box that matches the entry that was selected in the combo-box is highlighted. Nothing is moved. This works fine, I've been using this method for quite awhile and never any problems with it. The aspect that I have not been able to figure out is how to retain the focus on the combo-box, so the users can type, get to the entry they want, press enter and then type additional entries. Everything works on this except that the focus is lost whenever enter is pressed. I need the current combo-box to retain the focus.

Hi Bob,

I know there is a global setting for the do not move after enter but that would affect the whole database, which would not work. I need it just on this form. Any ideas?

Dan

If I were trying to do what you describe, I'd put code in the combobox's OnExit event that pointed back at the combobox..., something like (untested):

Me!cboMyCombobox.SetFocus

Thanks for the suggestion. I should have pointed out that I have tried about every event using the SetFocus and nothing has worked. When I do it with the "On Exit", the corresponding list-box gets the focus. This is driving me nuts. I mean I understand why it's happening with the Enter because it's assuming that the user is done and wants to move on to the next field but I would think there has got to be a way to sort of by-pass that, so the focus will remain on that control.

how about a textbox that gets the focus after the enter is clicked on the combobox. then the only thing the textbox does is have a setting that says when i get focus set the focus to the combobox. You can make the textbox the same color as the background and it should not look like one is there.

Bob, That did the trick, which I'm not understanding why it's working because I tried setting the focus to another combo-box and then redirecting back to the same combo and it didn't work but with this, it does. I already had a text box in place, so I just used that, I just basically did this.

Me.MyTextBox.SetFocus
Me.MyCombo.SetFocus

For whatever reason, it works this way. Thanks.

Hi Dan,


Not sure if this will be applicable or how it will affect your setup but, have you tried something like?


Just my 2 cents... (IMG:style_emoticons/default/2cents.gif)

Happy to help.

Hi DBGuy,

Your approach looks interesting. What are keycodes 13 and 0?

Hi Dan,


Keycode 13 is the "Enter" key. By assigning 0 to the Keycode, while the focus is in the Combobox, we are essentially telling Access to ignore it if the user hits the Enter key.

Just my 2 cents... (IMG:style_emoticons/default/2cents.gif)