Hi!
I have a public Function stored in a module "MyDates" that stores the fiscal
year, which is used in several forms and reports.

Public Function FisYear() As String
FisYear = DLookup("[FiscalPeriod]", "Dbo_AMC_Info", "[ID] = 1")
End Function

I want to be able to modify the value from a form's "FiscalYear" dropdown
box  but do not know how to change the value of a public function from a
private sub on change
The dropdown box pulls all available fiscal years from a table.

SELECT DISTINCT SH_PSUM.BUS_YEAR
FROM SH_PSUM;

Can I pass the selected value to the public function?
Here is what I need:

Private Sub FiscalYear_Change()
???????
End Function

Thanks in adavance!