i have the ff codes for showing the data report but an error occurred...
CODE
Private Sub cmdView_Click()
qry = "SELECT * FROM tblResDet WHERE RES_CODE = " & Val(frmBook1.lblResNo.Caption) & ""
Set ShowItinerary = myConn.Execute(qry)
If ShowItinerary.EOF <> True Then
DataReport1.DataSource = ShowItinerary
Else
MsgBox "No record found.", vbCritical
End If
DataReport1.Refresh
DataReport1.Show
End Sub
the error says "method or data member not found" where the word "datasource" in my elseif statement is highlighted..
pls help and thanks in advanced...
| 
