[RESOLVED] How to refresh a data report (VB6)

What should i do to refresh a data report so that I can see the new entries as well?

If you are using a DataEnvironment then you must close it's recordset.

Code:

---

        If de1.rsCommand1.State = adStateOpen Then
            de1.rsCommand1.Close
        End If
        DataReport1.show

---

Hi,

you may view this tread...
http://www.vbforums.com/showthread.php?t=423752&highlight=data+report+refresh


There was a thread on data report refresh that has another solution..I forgot where it is...

Greg

Thanks a lot!

Hi,


Ur welcome dude.....


Greg:) :)

You may rate this thread if my answers were helpful

Greg

Hi,
Please read the following code which i want to use to call the specific data from database putting bank name into combobox(cboBankName).

Private Sub cmdOk_Click()
If IsNumeric(cboBankName.Text) = True Then
DataEnvironment1.cmdAnimal cboBankName.Text
dptAnimal.Show
Else
MsgBox "Please enter a valid Bank Name", "Wrong entry"
End If
End Sub

It displays an error that: "Wrong number of arguments or invalid property assignment"