is it possible to open a current record in a report, what I mean is while the user is going over the records and lets say that he wanted to print the current record I need to open and print that record in a report so it would look more professional, how can I do that?

Thanks.

I would think this task would be better handled using a form ..
As you can not execute the needed code from within the report ...

RDH

Ok what about this code


Private Sub cmdPrintRecord___Click()

Dim strReportName As String
Dim strCriteria As String

strReportName = "ACAAudio"
strCriteria = "[ID]='" & Me![Text122] & "'"
DoCmd.OpenReport strReportName, acViewPreview, , strCriteria

End Sub


Where Text122 is the name of the textbox that has the ID for every record and ID is the name of the field on my table, but how can I specify which table?

//Edit, R. Hicks it’s a form its just I thought to post this question on the report form since it’s more suited.

Ok, I got it fixed, but when the report page opens how I can set to view on 100%, by default is sat to view on fit