How do I display different sets of records based on a selection?

[Bipbop]

I have a dropdown box (but I can change it if need be), and want a particular
form or report to open based solely on the selection made from it.

I am creating a training database, which works fine up until this point.
The dropdown boxx contains a list of the courses we supply. When a course is
selected a want to be able to print out a page displaying the contents of the
course. Is this possible? I have been searching for a solution for months
now.

 

[Allen Browne]

Add a command button to your report.
In the button's Click event procedure, use the OpenReport action.
Use the WhereCondition to limit the report to only those courses in the
combo.

There's an example here:
Print the record in the form
at:
http://allenbrowne.com/casu-15.html

 

[Designing-Systems.com]

hi,

Use the ON CHANGE event to triggger a query that selects records based on
the item selected in the drop down box.

Regards,

 

[Duane Hookom]

I generally avoid using the ON CHANGE event since it is triggered with every
key stroke. It would be better to use the After Update or a command button.