I am setting an ADO control's recordset in runtime and I want to display the records "SELECT....WHERE DateField = DateVariable"

DateVariable is input by the user into a text box and then converted from text to date;

DateField is defined as Data Type Date/Time in an Access Database.

But when I run the form, a message box 'ado Unknown' comes up.

What am I doing wrong?