Automatically picking up the month and year from the system

[Altaful Haq]

As there any way that i pickup a month and year from my system and assign it into the month field and year field.
situation
Attendance----- Month-------- year
26 -------------- DEC --------- 2013



it want that when my i add a new record the month and year field automatically filled.

[burrina]

Is that to be in 2 separate fields?

Somefield =Format(DateSerial(Year(Date()),Month(Date()),Day( Date())),"mmmm ") 'Current Month
Somefield =DatePart("yyyy",Now()) 'Current Year

HTH

[Altaful Haq]

where i had to put these codes.

[Altaful Haq]

it show the date which is 1905 which does not the date of my system

[burrina]

You put the for the Control Source for the field you want to show that result.