Reports

[Shakeel Ahmad]

I have a students information database in MS Access.

I have created following tables:

StudentsInformation
FeeStatus
Progress
CourseInformation

and the same forms.....

Now i have made the StudentsInformation form a Master form and other three
forms have been made subforms
and they have the view property (DataSheet view).

I want to make a command button (cmdReports) onclick it should take me to
the exact page which student is active on the form....

I would like to ask more questions about the reports.... but yet i need to
know only the above mentioned question.

Shakeel Ahmad.

 

[mray29]

The code under cmdReports can open the report and send it a filter string,
based on the text box on your form that contains StudentID.

For example,
DoCmd.OpenReport "rptStudents", acViewPreview, , "ID = " &
Forms.frmMaster.txtID

where Forms!frmTest.txtID represents the control on your form that contains
the ID for the student in question.

Be sure to set the report's Data/Filter On property to Yes.