Scrolling in a Combo Box

I've noticed that when I tab to a combo box control, I cannot scroll
thru the list (row source is a table) without selecting the arrow
first. How do you set it so you can scroll thru the list instead of
clicking on the arrow?

re: Scrolling in a Combo Box

Mark,

I don't know whether something like this is exactly what you want but I use
this style for my comboboxes -
it will drop the combo list when the user tabs into the control unless an
item has already been selected from the list.
This code belongs to the GotFocus event for the control.

Private Sub Location_GotFocus()
If IsNull(Me!Location) Then
SendKeys ("{F4}")
End If
End Sub


"Mark Lees" <mark_lees@byu.edu> wrote in message
news:c4f3d99f.0402032224.42161793@posting.google.c om...[color=blue]
> I've noticed that when I tab to a combo box control, I cannot scroll
> thru the list (row source is a table) without selecting the arrow
> first. How do you set it so you can scroll thru the list instead of
> clicking on the arrow?[/color]

re: Scrolling in a Combo Box

"Squirrel" <wiseowl@covad.net> wrote in message news:<62f6d$40209a8f$44a563e3$9522@msgid.meganewss ervers.com>...[color=blue]
> Mark,
>
> I don't know whether something like this is exactly what you want but I use
> this style for my comboboxes -
> it will drop the combo list when the user tabs into the control unless an
> item has already been selected from the list.
> This code belongs to the GotFocus event for the control.
>
> Private Sub Location_GotFocus()
> If IsNull(Me!Location) Then
> SendKeys ("{F4}")
> End If
> End Sub
>[/color]

Squirrel:
I tired but it didn't work. I've never entered code into a expression
before so this is what I did.

I selected the properties for the control (combobox). I went to the
event tab. Selected "On Got Focus". Brought up the expression
builder and typed in your code word for word.

When I saved it. It did not save the code.

So I'm doing something wrong. Please help.