problem with datareport

hi everyone

well i made a form that has textboxes, its more on curiculum vitae. .

what i want is when i click print button it will display the current record on the data report, but when i use this code

Code:

---

datareport1.show

---

it shows the first record and u have to click the next to find the record you what to print

anyone knows the code for when i click the print button it will display the current record im browsing into the datareport and not the first button

thanks in advance guys

Moved To Reporting

It depends on how you set the datasource for your report. Your datasource should contain only the record you want to print.

yeah

there are lot of records

lets say record 1, 2, 3, 4, 5 now im currently browsing record 3, wat i want is when i press print button it will show the datareport displaying record 3 not record 1.

Have you looked into this?

Code:

---

Dim rsR as new ADODB.Recordset

rsr.Open "Select * from yourtable where yourfieldname='" & selectedrecord & "'",conYourconnection

With DataReport1
    set .Datasource = rsR
    .Datamember = rsR.Datamember
    .Show
End With

---