In my Macro, I want users to select which records to view.

[Guest]

I am creating a database for a college program. To be as fully automated as
possible. In the program, students often get certifcicates for seminars they
have attended.

I want to create a macros to print one such certificate.
My plan:
Create a query which pulls first and last name of all active students who
have attended the seminar.

The macro will open a report/certificate based on the main table that is
filtered by this query.

However, the Report needs to be filtered one step further. currently it
will pull all active students who have done the seminar. However, second
year students, of course, would have already received a certificate.
I was hoping my macro could bring up some sort of dialogue box with a list
of hte qualifying students and the user could check off all the students they
want to have printed.

Any suggestions?

My backup plan is to add a date field in the table and form. It would then
be filtered by the date of the seminar.

 

[Guest]

Your backup plan IS the solution. You might want to filter by using something
similar to Date > Now - 30 to make it more generic (completed in the last 30
days).