Dear All,

i am using cr 8.5, vb6 & MS Access 2007.
My problem is that when i am trying to fetch data from access with the help of formula i receive this error:

A number, currency amount, boolean, date, time, date-time, or string is expected here.

The code is mentioned below:

strformula = "{trans.vdate} in date(" & _
Format(Combo1.Text, "dd-MM-YYYY") & ") to date(" & _
Format(Combo2.Text, "dd-MM-YYYY") & ") AND {trans.accode}= " & Chr(39) & Combo4.Text & Chr(39)

trans.accode is the text.