Advice request: Retaining focus on a record-navigation listbox (1 Viewer)

[Duff-Man]

Hi all,

I have several forms which use a listbox for record navigation (in addition to forward/back buttons). The listbox works well when navigating the form via mouse & keyboard; however, some users of the form prefer to enter data via keyboard only.

When tabbing into the listbox, I would ideally like to be able to scroll through the records without losing focus on the listbox, and retaining the highlighted row position.

Alternatively, it would be fine to scroll through the listbox without switching records, and require the user to press Enter to jump to a record, and lose focus.

Any advice on how I might best approach this? Thanks.

 

[arnelgp]

if you like you can add a Command button that will GoTo the record (from the selected item in the listbox).
set its property to Default Button to Yes, so whenever Enter key is pressed the button will get Clicked.

 

[arnelgp]

here is a demo. you can press "Enter" to go to the record.
you can also "double-click" on the List item to go to the record.

 

[cheekybuddha]

I haven't looked at Arnel's sugggestion, but really you just need to add an extra command in your listbox's AfterUpdate event.

Eg if your listbox is named 'lstSelect', you can use something like:

Private Sub lstSelect_AfterUpdate()

  ' code that performs the form requery
  Me.lstSelect.SetFocus

End Sub

 

[isladogs]

I'm unclear what you are asking.
Scrolling through a listbox will not (NORMALLY) change the selected record

However, it is possible to use code to 'select' a listbox record by scrolling. See:

Listbox Mouse Move Item Tooltips

This shows show how listbox items can be 'selected' using a mouse move event without clicking the listbox. This can be used to show e.g. images and tooltips for each row item. The code works even where a vertical scrollbar is needed to view all listbox items.

www.isladogs.co.uk

Also these articles may be of interest?

Continuous subform selection using the vertical scrollbar

Normally, when the vertical scrollbar on a continuous form scrolls through the records, it doesn't change the 'current record' i.e. no selection is actually made without clicking. However, this example app shows how records in a continuous subform can be 'selected' using the vertical scrollbar.

www.isladogs.co.uk

Synchronise SubForm Scrolling

This shows several methods of synchronising the horizontal or vertical scrolling of two (or more) continuous or datasheet subforms. This includes an approach where no code is needed as well as more powerful methods involving code.

www.isladogs.co.uk