how to auto update in a field on the table?

[viccop]

Thank for your attention. I'm new in access, and i have problem with update command. i need to update with request as follows: "For example, in a table, i have two field -- MONTH, COLOR --. the table exist one record row is -- 1/2009, BLUE -- now, in a form of this table, i will add new record with MONTH is 2/2009, and i want COLOR field will be default display same as the color of 1/2009 month record (is BLUE). what i have to do? Thanks in advance!

[thhui]

You must write VBA code to search the last value of the required field you have entered and
post this value to the new record on the NewRecord event.