print a selected record using listview

[eliajah]

Hi!

how can i print the selected record? I'm using vb6..i used combo box,texbox and listview...i just want to print the selected record however it print all the record from database?

[redz]

what do you mean?
are you selecting a racord by searching in a textbox or something? try this..
you have to specify your query first..

select * from tablename where fieldname like '%" & textbox1.text & "%'

i am using crystal report for printing records..