MS Access: Display a particular subform based on a combo box selection in Access 2003/XP/2000/97

We've provided a download to demonstrate how you can select a value from a combo box and then display a particular subform.

In our example, we have 3 subforms called frmJobs_Customers_sub, frmJobs_Employees_sub, and frmJobs_Supplier_sub. We've created all 3 subforms on our main form (frmJobs) - with each subform being placed on top of the next.

Then based on the value chosen in the Template Type combo box, we've hidden the subforms that we don't want to see. So that only the appropriate subform is currently being displayed.