crystal reports SelectionFormula

[Caro]

I am using a CrystalReport1.SelectionFormula which isnt working from VB6(I take this line out and the report works OK) Yet when I cut and paste the select string into the crystal report directly it works. Does anyone know why this could be happening? (only on one of my reports.)

[Glenn]

Post the line and maybe we can help

[Caro]

{Enquiry Detail.Status} <> 'D' and {Enquiry Detail.Enquiry Date} >= Date (1999,01,12) and {Enquiry Detail.Enquiry Date} <= Date (1999,10,04) and {Enquiry Detail.Supplier} = 'ETIPACK spa'