table field name "Year" causing Argument Not Optional

[JosmithTwo]

I have a table with a field name "year". When I try to execute the following code I get "argument not optional". HOWEVER, if I run the same code and data on another Access 2007 machine, both running win XP it works just fine.

Private Sub Form_BeforeUpdate(Cancel As Integer)
Mo = inMonth
Year = inYear   <<<<<<<<<<< If I change this to theYear = inYear the error goes away but the record is not updated.
Region = Left([CustDisplay]![CUST_SLS_TERR], 1)
Rep = [CustDisplay]![CUST_SLS_REP]
Select Case reynCsiOpt

Year = inYear <<<<<<<<<<< If I change this to "theYear = inYear" the error goes away but the record is not updated.

Jim

[June7]

This is why using reserved words as names should be avoided. Enclose in [].

[alansidman]

For the future and all others looking at this thread, here a listing by MS of reserved words.

http://office.microsoft.com/en-us/ac...010030643.aspx