RELATED TO VB6 USING TABLES FROM MS-ACCESS DATABASE

I HAVE A TABLE 'VOUCHERS' CONTAINING FIELD VDATE(datatype: date).

i store 'txtfrom.text' into date_1(datatype:date) as

date_1=txtfrom.text

and

date_2=txtto.text

sql-command -
select vdate from vouchers where vdate between ' " & date_1 & " ' and ' " &date_2& " ';

THIS COMMAND IS SHOWING THE ERROR :' DATA TYPE MISMATCH'

i have tried other forms to like removing ' ' and " & &".....
but it is not working........
pls help me

can you show the whole code? It's hard to diagnose what's going on with just bits and pieces.

guess data in date_1 and date_2 are not in the right date format. try displaying the sql query and see how does it look like. this helps so much to identify the bug in your query