hello. how to do if when we double click at list view, then the information from list view will be appear at label. many times i tried but always debug (run time error '_2147217904(80040e10) 'no value given for one or more required parameter) .
Private Sub ListView1_DblClick()
checkConnection
strSql = "SELECT * FROM Schedule WHERE ReservationCode=" & ListView1.SelectedItem.Text & ""
rec1.Open strSql, con, adOpenStatic
lblReservationCode.Caption = rec1!ReservationCode
lblDestination.Caption = rec1!Destination
lblDate.Caption = rec1!Date
lblTime.Caption = rec1!Time
End Sub