Access Form help in using data field to auto populate another field

[Ella359]

I have a Form I've created for data entry to track events. One of the fields is "Date of Event" and another entry field is "Fiscal Year". I'd like for the "Fiscal Year" field to be auto populated depending on the response given in "Date of Event". Basically I want it to work off of a range - 10/1/2014-9/31/2015. So if an event occurs some where in this range the "Fiscal Year" field auto populates to the corresponding FY 15.

Assistance would be greatly appreciated!

 

[SkipVought]

forum702

 

[Ella359]

Thank you...I'll repost in the correct forum.