Now that I have built the calendar for appointments, I would like to use it for other types of events such as standby manning, equipment service dates, medicine expirations, etc.. All these items are in different tables so my question is this: Can I just reset the rowsource for the listboxes in code via a loop of some sort or do I have to reinvent the wheel on the calendar form for each different usage? I know I would have to create different queries for each usage but recreating the rowsource is the labor intensive part I am trying to automate. Thanks as always for your help.
Reply from Alexander Hedley:
Are you wanting all of these in the same db? If not just input these events in the CalendarT in separate dbs and they'll show up. Just name the db differently.
Another option is a UNION Query but keep it called CalendarQ and the Forms will still work.