Date Conversions

[kingrexx]

I am new to Access, and I am trying to build a form that tracks requests by month/year. My problem is that we don't use a standard calendar, so I need to do a look up to a secondary table to check if the request date is in a date range and then populate 2 fields in the table with the alternate Month and Year..

The process flow is something like this:

User enters data for Table1.Request_Date
AfterUpdate Check to see if Table1.Request_Date => Table2.Start_Date And Table1.Request_Date <= Table2.End_Date

If a Match is Found then Update Table1.New_Month with Table2.Month and Table1.New_Year with Table2.Year

If No matches found, then generate an error.

I am stuck on how to start coding this. Any help would be appreciated.