The field will be for information only. It is a 4 digit year field (numeric) so the the Switchboard will the present fiscal year and next year (fiscal year + 1) At one time I could do this but I forgot how. I believe it should be something like =[my info].[fiscalyear] (=[tablename].[fieldname]) in Control Source. -------------- I was able to find the answer, use DLookup() include field name and table name and enter it as Control Source in an unbound text field on a form.

You can use DLookup() in the Load Event of the form.

Me.FiscalYear = DLookup("FiscalYear","sometable", "somecriteria")
Me.NextFiscalYear = Me.FiscalYear + 1

Thanks

Bob