Hi All
I am trying to learn Access and have come across a problem and have spent the day looking for an answer.
There are 2 Tables, 2 Forms, one of which is a subform, and 2 Reports, one of which is a subreport.
I checked out the Microsoft Website and came up with some instructions of How to Print a Single Record from a Form in a Report. I followed the instrcutions using the Northwind.mdb, but nothing happened.
I have also tried some other coding that I was sent by another Guru. that didn't work properly either. OK, I did get the Labels in the report. None of the date.
The code for this is as follows:
Private Sub cmdPrint_Click()
DoCmd.OpenReport "rptTrainers", acViewNormal, , "[lngTrainerID]=Forms!frmTrainersDetails!lngTrainerID"
End Sub
Can anyone guide a Newbie?
TIA
Ken
I am trying to learn Access and have come across a problem and have spent the day looking for an answer.
There are 2 Tables, 2 Forms, one of which is a subform, and 2 Reports, one of which is a subreport.
I checked out the Microsoft Website and came up with some instructions of How to Print a Single Record from a Form in a Report. I followed the instrcutions using the Northwind.mdb, but nothing happened.
I have also tried some other coding that I was sent by another Guru. that didn't work properly either. OK, I did get the Labels in the report. None of the date.
The code for this is as follows:
Private Sub cmdPrint_Click()
DoCmd.OpenReport "rptTrainers", acViewNormal, , "[lngTrainerID]=Forms!frmTrainersDetails!lngTrainerID"
End Sub
Can anyone guide a Newbie?
TIA
Ken