Try something like

rs!DateField = "" & txtdate

Hope it helps.