Hi All, Help for cmdFind_Click () & cmdPreview_Click (). I am trying to self teach, and my teacher is not too bright !!! I have a .exe program with a small database (written with VB6) with only 5 Fields: Record (counter) Stock Description SoldTo ItemPhoto I need help with cmdFind_Click() - Need to find any record by String as well as Integer, as you can see I can only find the Integer Private Sub cmdFind_Click() Dim Record As Integer Record = InputBox("Enter the Ref of the required contact: ", "Find Contact") Data2.Recordset.Index = "Record" Data2.Recordset.Seek "=", Record End Sub. Is there a way the ItemPhoto can be viewed within the form ??? Private Sub oleItemPhoto_DblClick (Index As Integer) oleItemPhoto(Index).InsertObjDlg End Sub How can I sort the report on Stock ?? Private Sub cmdPreview_Click() DataReport1.Show End Sub. Lucky1

use SQL for searching for records.... about the photos: save file's address(folder) in use dbase and retrieve to make the photo appear use IMAGE for your photos... the command is LOADPICTURE