Check out my new article on how to use multiple instances of the same sub-form to create a calendar in MS Access.

I find this technique useful in a variety of situations, but more so in the case of calendars or when working with dates.  The article contains a sample database which includes tables for Providers, Patients, and Appointments, along with the forms necessary to view the calendar and add or edit information to the appointments calendar.

Enjoy!