I spent hours searching in google how to set today date in a form with a macro and couldn't find a solution (the only solution given was to add a SQL command to default new record but it's not working when the date field is not attached to a table row)
So I thought I would share mine here, hope this is a good place.
- Create a macro like :
Code: Select all
Sub SetDate (oEvent As Object)
oForm = oEvent.Source
oForm.getByName("inputDate").Text = Date()
End Sub