Calendar control and date range help

[elite311]

I'm looking for some help, I haven't been able to figure this out and I have searched the fourms for the answer already but haven't come up with anything. I have a form that I have put the Calendar control v.11 onto and under that calendar I have 4 text boxs. (1)-Tech name (2)-Tech cell number (3)-Delivery driver name (4)-Delivery driver cell.

I have 2 tables created, (1)-T_TechOnCall and (2)-T_DriverOnCall. Both of these tables are setup the same way, Name, Start Date and End Date.

I want to be able to put a date range in the table and then be able to click on a day on the calendar and it populate the text boxs with the tech and driver on call for that day depending on the date range entered in the table. So if he is on call from the 5th-10th any day I click between those dates his name comes up.

The cell number and names for the tech and drivers are in T_Service_Tech_Info, and T_Driver_Info basically the On Call tables name field is a lookup value from those tables.

I'm not sure how to acomplish this, any help would be greatly appreciated.

Thanks

 

[elite311]

Any ideas on this? I tried using a Query and got it to kinda of work but just with one date. I need it to work accross a date range and not sure how to do it.