I have a form which has a Listbox and an unbound combobox. When a user selects an item on the Listbox I want that ClickEvent to Select an item in the combobox. I'm not getting an error but nothing is happening.
The Listbox and the Combobox both refer to the same table.
My code I attempted is:
Private Sub ListCity_Click()
On Error GoTo ListCity_AfterUpdate_Err
DoCmd.SearchForRecord , Me.cboSelectCity.Column(0), acFirst, "[CitiesID] = " & (Nz(Me.listCity.Column(0), 0))