Insert date function

[geraldk]

Hello,



I am having problems, I need to insert values from my form in a date function and when it's insert into my tables it gives me time value instead of a date. Before I insert the values I format the date value I format the date into MM/DD/YYYY

     
    strdate = Format(Me.txtEMPVACDate, "MM/DD/YYYY")
    
   
    strINSERT = "INSERT INTO TBLEMPVAC values (" & Me.txtEMPVACID.value & ", " & Me.txtEMPID.value & "," & Me.cboVACID.value & "," & strdate & ")"
       
        
    DoCmd.RunSQL strINSERT

Can anyone see what I am doing wrong in the statement above to help me?

Thank you,

Happy New Year

[geraldk]

sorry I forgot to post this.

When this date get saved into the table is shows 12:00am.

[pbaldy]

Dave values need to be surrounded by #.