I have a Form that displays demographic information on trainees at our hospital. It has 2 subforms....
Subform 1: Each record is of an annual rotation, with start & end dates, such as 3rd year medical student, 4th year medical student, etc.
Subform 2: Each monthly rotation...which department are they going through that month, with start & end dates.
The form also has a button to generate a computer access form that is based on a query that accesses tables updated by the subforms. The access form differs from trainee to trainee based on their education level & which rotation they are doing.
The problem is that the when the access form report button is clicked, the report displays a separate page for every record in Subform1 (which would be every record that exists in that table for that person).
How can I get the report to ONLY display an access form for the most recent annual rotation?
Subform 1: Each record is of an annual rotation, with start & end dates, such as 3rd year medical student, 4th year medical student, etc.
Subform 2: Each monthly rotation...which department are they going through that month, with start & end dates.
The form also has a button to generate a computer access form that is based on a query that accesses tables updated by the subforms. The access form differs from trainee to trainee based on their education level & which rotation they are doing.
The problem is that the when the access form report button is clicked, the report displays a separate page for every record in Subform1 (which would be every record that exists in that table for that person).
How can I get the report to ONLY display an access form for the most recent annual rotation?
