I fixed it.. sort of. Since the end user has 2010 anyway, I changed the date picker controls for text boxes, and now the form works completely. I've included a copy in case anyone else wants to see it, or if anyone has ideas for tweaking it. The workbook its on is a small sample. The real file has hundreds of employees across 12 different worksheets. Any ideas on making this work as fast as possible for the end user would be much appreciated.

tickettemp1.xlsm