, [Date], [Month], [Year]

those are reserved words.. u need the brackets (or change the names)
and if the field is a date time field then...

, #" & tDate & "#, '" & tMonth & "', '" & tYear & "'