Private Sub cmdShowAll_Click()
lstMovies.Clear
Do While Not Data1.Recordset.EOF
lstMovies.AddItem Data1.Recordset.Fields("Title").Value
Data1.Recordset.MoveNext
Loop
Data1.Recordset.MoveFirst
End Sub
Private Sub cmdViewInfo_Click()
Let strsearchfor = lstMovies.Text
frmMain.Hide
frmInfo.Show
Let intfound = 0
Do While intfound = 0 And Not Data1.Recordset.EOF
'// ("Titles") <= wrong
If Data1.Recordset.Fields("Title").Value = strsearchfor Then
Let intfound = 1
Else
Data1.Recordset.MoveNext
End If
Loop
Data1.Recordset.MoveFirst
If intfound = 0 Then
MsgBox "no record"
Else
frmInfo.picInfo.Print strsearchfor
End If
End Sub