range between 2 dates (1 Viewer)

[history]

Hello brothers,

I have a table called "EmpVisaType" consist of EmpVisaType - date1 - date2
EmpVisaType CompDate1 CompDate2
A / 01/01 /31/01
B / 02/01 /28/02
C / 03/01 /31/03
D / 04/01 /30/04
E / 05/01 /31/05
F / 06/01 /30/06
G / 07/01 /31/07
H / 08/01 /31/08
I / 09/01 /30/09
J / 10/01 /31/10
K / 11/01 /30/11
L / 12/01 /31/12

and I have a Form (based on another table) and on it I have some objects :
Entry Date text box for date
EmpVisaType Combo box (based on EmpVisaType table)

what I need

when the User enter a date in Entry Date text box, ex: 15/04/2004
automatically select the EmpVisaType from the combo box according to the dates mentioned in EmpVisaType table, ex: D .

Thanks in advance