1) Have I missed something - No matter what date I click on the calendar control it opens to the same place in the month.  

2) because dblclick event on the list box only opens existing data, I have used the date text box double click event to open the CalendarF to add mode.  I have set the CalendarF to requery on close, but I have to close the MonthlyCalendarF to have the new data show up.  Can I requery the MonthlyCalendarF from the CalendarF?   Also  I used a macro to open the form and I am concerned that creating 42 macros in the Date Text Boxes will make my database sluggish.
  

---

Reply from Richard Rost:

Dana, (1) if you open the calendar control and its based on a date that has no value, it will always appear to open to the same date. To change that, assign it a date value. I believe I covered this in one of the lessons.

(2) You can requery the data in another form like this:

Forms!MonthlyCalendarF.Requery

(3) I wouldn't worry about 42 macros making your database sluggish. That shouldn't be a problem, but you might want to ask yourself WHY you need 42 macros? Can you make one bit of VBA code and just send it the control name? When in doubt, VBA is always better than a macro, IMHO.