J
jean
Hi
I have a report based on a query.
On this report I have maybe 10 text field with formulas like =DLookUp
("[PeriodName]","[TblPeriods]","PeriodNo =15").
When I click to open the report a pop up window opens "Enter Parameter
Value PeriodNo"
I can put anything or nothing and when I click the OK button the
report opens perfectly.
As I cannot change the query to include "PeriodName", i have to stay
with formulas.
I did a test and delete all text fiels containing formulas like DLookUp
("[PeriodName]","[TblPeriods]","PeriodNo =xx"). and the pop up don't
appear anymore.
So, I don't thing my formulas are wrong and i want to know how can i
skip the "Enter parameter Value" pop up window.
Just to let you know : If i open the query alone ... no problem. I
don't have sorting on this report. So the trouble comes only from
formulas.
What can i do ?
thanks
I have a report based on a query.
On this report I have maybe 10 text field with formulas like =DLookUp
("[PeriodName]","[TblPeriods]","PeriodNo =15").
When I click to open the report a pop up window opens "Enter Parameter
Value PeriodNo"
I can put anything or nothing and when I click the OK button the
report opens perfectly.
As I cannot change the query to include "PeriodName", i have to stay
with formulas.
I did a test and delete all text fiels containing formulas like DLookUp
("[PeriodName]","[TblPeriods]","PeriodNo =xx"). and the pop up don't
appear anymore.
So, I don't thing my formulas are wrong and i want to know how can i
skip the "Enter parameter Value" pop up window.
Just to let you know : If i open the query alone ... no problem. I
don't have sorting on this report. So the trouble comes only from
formulas.
What can i do ?
thanks