Hello
First of all, it would point to crptReport.Active = 1 because that's when
the formula is being read by the OCX.
check that your formula has all the (), {}, and ''.
when the msgbox pops up with the error, choose debug and write
?crptReport.selectionformula in the immediate window.
Lior langer
Quote:
>I have a vb form which accepts user input and constructs a Selection
>Formula. The program also has two dialog boxes, one to get the location
>of the report file and the other to get the location of the database
>file. When I run my program, I get an error that says:
>Error 20515
>Error in formula
>Then it points me to the line:
>crptReport.Active = 1
>Someone please help.