I have a 5 record database for learning purposes, with a MS Calendar Contol, I believe its 8.0 the compress file has it. I can retrive records using If then with the value of the calendar, but that would require I have a if then for thousands of dates. I can not seem to find the right syntax for a select Statment. What I need from coder is that code to make it find the record to go with that date. Also is there a way to have the calendar add a record for a date that is not in the datbase already?
## Deliverables
1. code to have calendar control find record that matches that date.
2. code to have calendar control add record not in database already.
## Platform
Windows XP
MS Access 2002