Determining Month as Integer from Date 1

[ShannonSkipper]

When I put a Date in a field called sDate I want a field called StartMonth to automatically set its value to the coresponding Month as an Integer. So if the sDate value is 9/12/1999 I need the StartDate value to be set to 9. Should I use an "on lost focus" event procedure? Any ideas?

Thanks much for your help,
Shannon

 

[RoyVidar]

Since you shouldn't store a calculated field/a field that can be derived from another field, I'd say just use a controlsource of =Month([sDate]).

Roy-Vidar

 

[TheAceMan1]

ShannonSkipper . . . . .

In the [blue]AfterUpdate Event[/blue] of [blue]sDate[/blue] try this:

[blue]Me!StartMonth= Month(Me!sDate)[/blue]

See Ya! . . . . . .

 

[ShannonSkipper]

Works perfectly - Thanks!!!