Reports

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Shakeel Ahmad - 30 Jul 2007 15:19 GMT

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.

Reply to this Message

mray29 - 30 Jul 2007 20:12 GMT

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.

> I have a students information database in MS Access.
>
[quoted text clipped - 18 lines]
>
> Shakeel Ahmad.

Reply to this Message