It works now. Thanks for the help!
One more thing, is it possible to display the date in my form as say 11 Dec 2014 rather than 11/12/2014? Meaning, when the form loads, it pre-populates the text field with the date from the recordset in 11 Dec 2014. Then when I pick a date from the picker, it can also display in the same format. When the form submits, it will send the date according to MySQL's format.