Guys! im doing a search program where in ill just search the name of the product then print it.

Private Sub txtSearch_Change()
rsTransaction.Close
rsTransaction.Open "select * from tblTransaction where mid$(Date,3,2) like '" & txtSearch.Text & "%'", con, 3, 2
end sub

it is actually doing fine but i really dont know how to print that selected item on datareport? i try to do it but it print the whole table on the database to the page.

i just want to make a daily report of my database :(

help me please?

You need to pass only the desired record set to the report not the entire table.