So I am using the Combo box to select a record using:
Private Sub TPComboBOx_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[TestPoint#] = " & Str(Nz(Me![TPComboBOx], 0))
If Not rs.EOF Then Me.Bookmark =...
Hello,
I am trying to have 2 Command buttons to go to previous and next record based off an unbound combo box selections. I currently have the next command button code via VBA but I don't know how to do the opposite for a previous button. This is the code I am using for a next record:
Function...
I have the same issue. If the combo box has a selection made, then I get the runtime error 7777 Listindex property error. Once I clear the selection from the combo box, then I don't get the error. Missinglinq, do you know how to fix this?