Drop Down Plus Navigation

[shank]

I have a drop down "VendorSku" on my form with a query source. Defaults to first value. Works great.



How can I add buttons as an optional way to navigate through the drop down? Neither the standard form navigation or the navigation buttons I added with navigate through the drop down list. It would be convenient for the user to click through instead of having to drop down each time.

Thanks!

[June7]

Not really understanding what you want. How would buttons navigate (scroll ?) a combobox drop down list?

Code can cause list to automatically drop down when combobox gets focus. Typing in combobox 'navigates' by applying AutoExpand feature.

[shank]

Imagine your typical select state drop down. You can optionally use arrow keys to get the previous and next value without having to drop down. My drop down does not change with arrow keys or navigation buttons. Just trying to give the user an option. In this case, the drop down provides values for 3 more subforms. Additionally, they will have view all values in the drop down to finish the task. There's 10 or so values.

Thanks

[June7]

"typical select state drop down" - typical where?

Access combobox list must drop down for cursor keys to work.

Private Sub cbxState_GotFocus()
Me.cbxState.Dropdown
End Sub

Or use a listbox.

[shank]

"typical select state drop down" - typical where?

Go to this page for a typical drop down:
https://wholesaledropship.com/reg.asp

You can drop down or use arrow keys for previous and next records. It's ASP and not MS Access, but this is what I mean by typical drop down.

Thanks!

[Welshgasman]

Now crossposted at https://www.access-programmers.co.uk.../#post-1820804

[isladogs]

Exactly the same occurs with an Access combo. Once the dropdown is visible the up/down arrow keys move the cursor position.
It also works for a listbox.

[shank]

Exactly the same occurs with an Access combo. Once the dropdown is visible the up/down arrow keys move the cursor position.
It also works for a listbox.

Correct, in that once you drop it down, arrows work. But in the ASP sample I provided, you don't have to drop it down. You can tab to it from the city box and use arrow keys without dropping it down. I guess it's just the difference between ASP and Access.

Thanks for your help!

[June7]

Okay, point taken. AFAIK, Access combobox will not allow that. Access form and its controls is not a web page. I have never run across code trying to emulate this. That could mean trapping the up/down cursor key presses with KeyDown event, increment the row position with each cursor press and of course, if they press up arrow, reduce the position. Or instead of trapping key presses, maybe your idea of up/down command buttons could be applied, although a form in datasheet view will not allow that.

Simple to just open list. Did you see and try code in post 4?

[isladogs]

I'm still unclear why buttons are being suggested to change something that already works in a simple way into something unnecessarily complex.

If you use a listbox, it is possible to 'select' a record just by moving the mouse up /down over the list without clicking.
A listbox is always dropped down and the mouse move code makes navigation very simple.
Your only restriction is that the listbox must show all records with no scrollbar.

If that idea sounds interesting, you can see it in action in Forms 4 & 5 in my example app https://www.isladogs.co.uk/move-form...ols/index.html

[Micron]

Not that I think it's practical to go line by line through a combo list rather than drop it down and use scrollbar to advance row by row or page by page, but you could use keydown (I think down arrow is key 40) and advance the combo list index value, as in

Me.myCombo.ListIndex = Me.myCombo.ListIndex + 1

Of course, more code would be needed to back up in the list, as well as trap for being at the beginning or end of a list. Big pain for small gain.