Hi!
I would like the "cells" in my report to change format (bold/color etc) according to the value of a checkbox in a query. The query is the same query that the report is based on. I've tried making a formatting rule on the field under "conditional formatting".
The problem is that when I open my report I get a pop-up box telling me to give a parameter value for the query (the query used in the formatting). No matter what I type there the report opens asd usual without formatting.
I have tried a similar variant of this earlier where I formatted according to a value given in a form combo box and that worked well if I didnt close the form in VBA after opening the report. If I closed the form the formatting didnt work, but I got no pop-up box like I get now.
Please, what am I doing wrong?
I would like the "cells" in my report to change format (bold/color etc) according to the value of a checkbox in a query. The query is the same query that the report is based on. I've tried making a formatting rule on the field under "conditional formatting".
The problem is that when I open my report I get a pop-up box telling me to give a parameter value for the query (the query used in the formatting). No matter what I type there the report opens asd usual without formatting.
I have tried a similar variant of this earlier where I formatted according to a value given in a form combo box and that worked well if I didnt close the form in VBA after opening the report. If I closed the form the formatting didnt work, but I got no pop-up box like I get now.
Please, what am I doing wrong?
