User enters a date so the correct Accounting Period is assigned.

[graydon123]

I have 2 tables from my database, one an employeeinfo table and another called accountingperiod. The employee table consists of fields "empFirstName, empLastName, empSSN, empHirePeriod." The accountingperiod table consists of the fields and a couple of sample records :
"acctPeriod acctPeriodDateBeg acctPeriodDateEnd "
----------- ----------------- -----------------
200401 01-12-2004 02-22-2004
200402 02-23-2004 04-04-2004

I am looking for a way that a user enters a date and then searches for correct accounting period in which date belongs to.

example: user enters '02-02-2004' in txtDate.text
then txtAcctPeriod.text will populate with '200401'
Once I get the correct AcctPeriod, then I will be able populate the employee's record with the AcctPeriod.

This is almost like a zipcode lookup...A user enters a zipcode and then the correct city&state is displayed.

Thank you for your help.