problem with datareport

[creek16]

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

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

[Hack]

Moved To Reporting

[wes4dbt]

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

[creek16]

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.

[dee-u]

Have you looked into this?

[wes4dbt]

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