Can someone help me? I'm having trouble displaying filter records in data report. I'm trying to print the selected records by date using filter, but when I print it, all the data in database are display instead of the selected one. Can someone help me?
Thank you. Here is my code:
- Private Sub Command3_Click()
- On Error Resume Next
- DataEnvironment1.rsCommand1.Open "select * from patients where ID & Lastname & Givenname & DateNow = ''"
- DataReport4.Refresh
- DataReport4.Show
- DataEnvironment1.rsCommand1.Close
- End Sub
- 235 views