Calculated Field

[Duane]

I have a combo box that has a list of years, i.e. 2008, 2009, 2010, etc.
What I would like to do is have the calulated field to display the first day
of the year after the combo box updates.

Is this possible?

Thanks in advance.

 

[Douglas J. Steele]

You can use the DateSerial function to generate that date in the combo box's
AfterUpdate event. Something like:

Private Sub cboYear_AfterUpdate()

Me.SomeTextbox = DateSerial(Me.cboYear, 1, 1)

End Sub

 

[Duane]

Thanks Doug.

Much arppreciated

You can use the DateSerial function to generate that date in the combo
box's AfterUpdate event. Something like:

Private Sub cboYear_AfterUpdate()

Me.SomeTextbox = DateSerial(Me.cboYear, 1, 1)

End Sub