report in subform

[zxmax]

Hi all,

I have a Form with subform , In my subform i have a Print option, that allow me to print a report ,

My problem is, every time run that report, it shows all the records, of the database for that subform ,
i would like it to print only the current Record,

Eg:

In my mail form, i have "UserID" , "firstName" , "LastName", "PhoneNumber"
In my subform , i have some transaction related to the main form,

what do i do to make access print only the transaction for that specific UserID ??

Thnaks in advance

 

[hneal98]

Pass the userid to the report.

 

[zxmax]

Hneal98 , thanx for the reply,
How do i do that ? i do have relationship between the UserId and the transactionID , im' a still a rookie at access

Thanks, in advance