Highlight the Current Form Record in a Microsoft Access ListBox
Question details
Highlight the ListBox item that matches the current record on a Microsoft Access form.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- A form has a ListBox that should track the selected record as the user navigates between records.
- Observed behavior
- The ListBox should highlight the item whose bound-column value matches the current form record.
Identify the ListBox control name and the form field whose value matches the ListBox's bound column. Check the ListBox's Property Sheet to confirm that Multi Select is set to None.
Update the ListBox in the form's On Current event
Use a VBA event procedure to select the matching ListBox item whenever the form moves to a record.
The form's Current event runs when the current record changes. Assigning the record's field value to an unbound ListBox selects the item with the matching bound-column value.
In the Navigation Pane, right-click the form and select Design View. Select the ListBox and use its Property Sheet to check its Name, Bound Column, and Multi Select properties.
Select the form, open its Property Sheet, and choose the Event tab. In the On Current row, select [Event Procedure], then click the ellipsis button to open the VBA editor.
Inside the Form_Current procedure, add: Me!ListBoxName = Me!CustomerID. Replace ListBoxName with your ListBox control name and CustomerID with the form field that matches the ListBox's bound column.
Save the form, open it in Form View, and use the record navigation buttons to move between records. Check that the matching ListBox item is highlighted.

Work with tabular data in WPS Spreadsheets
For spreadsheet-based work, WPS Office is a free, lightweight alternative with a familiar interface and Microsoft Office format compatibility to help you migrate existing files. It does not replace Access forms or fix their VBA event behavior.

Frequently Asked Questions
Where do I add the code for the form's Current event?
Open the form in Design View, select the form, and open the Property Sheet. On the Event tab, set On Current to [Event Procedure] and click the ellipsis button.
Why doesn't the ListBox highlight an item?
Check that the current record's field value exists in the ListBox row source and matches its bound column. Also check that Multi Select is set to None and that the control and field names in the code are correct.
Does the ListBox need to be bound to a form field?
No. An unbound ListBox can display the current record's selection without writing the selection to a form field. Check its Control Source on the Property Sheet.
Can WPS Office run this Access form event?
No. The On Current event and its VBA code are Microsoft Access features. WPS Spreadsheets can work with spreadsheet data but does not run Access forms.




