First off thank you everyone for the help that you have provided on this db so far. Hopefully this is the last error for this db. I am getting a run time error when I double click on my calendar. The calendar worked as advertised thanks to cyberlynx, but I had to change/remake a table. The table is exactly the same as before except that the date is formated to date/time instead of text, and the primary key is set to increment instead of random. Now though when I dblclick a date I get a runtime error, evidently I missed something becase the code looks good to me. Any way please open the db and see for yourself. I would appreciate a fix.