Setting Date DafaultValue on a form in MS Access
Posted on 2012-03-29
I have a form that pops up when a command button is pressed. The calling form has values I'd like the called form to initiate as Default Values, ie Text1.DefaultValue = Forms!Mainform!MainformValue.
All this seems fine EXCEPT for date values. I have two bound date fields on the popped form and I'm trying to populate them with dates on the calling form. But all I get is a time format, 12:00:00 AM. There's no formatting on the called form text box.
I've tried the code to set the date values in the On Open, On Current and On Activate Events. None of them work.
I even try to just set the default value to Date(). Even that didn't work.
No problems with references.
There's no default value in the table. The Text Box doesn't have a default value, till I set it.
I'm not sure what's going on.
Any help would be greatly appreciated.