current date button

[bricklebrit]

Hello,

I am attempting to create a button that when clicked in the form that will put the current date in the [OrderDate] field. Is there a simple command to to do this?

Thanks in advance for your assistance!

 

[Graham T]

briclebrit

Try the following:

Private Sub [YourButtonName]_Click()

    Me![YourFieldName] = Date

End Sub

HTH

 

[bricklebrit]

HTH -

Thanks for the prompt response -- works brialliantly.

 

[David R]

You can also set your OrderDate field to Default: Date(), that way a new record will automatically have this without the extra buttonclick. That may not serve your needs, just giving an alternative option.

Good luck,
David R