I have developed a ms-access form and subform. In the subform there is date field. I want to default this date field to today’s date. How can I achieve that ? Also once a record is entered I don’t want that field to change again.
Meaning if I am entering record on 15-08-2013 then date should default to 15-08-2013. But once record is saved that field should always remain 15-08-2013. If I open it today it should not change to 27-08-2013.
Is this possible ?