Hello All!
I have an inventory report titled "KitchInv".
Some of the inventory items are consumable, like trash bags, and others are (obviously) non-consumable like measuring cups. In the underlying table, there is a yes/no field called "Consumable".
I know I can use VBA to change the font color of the consumable items to red while leaving the others black. I do this in the Detail On Format of the report.
(I want the consumable items red on the report so the kitchen helper knows what needs to be counted on the last day of camp)
However, sometimes I want to run the report with all the text black.
What I would like to do is have a prompt when running the report asking if the items should be a different color.
That way I can make changes to the report ... what I mean is that I did have two reports ... one that prints with all text black and the other that prints with the consumable items red using conditional formatting. I made changes to one report ... font size, spacing, etc. and then I have to change the other. I'd like one report.
I can't add a parameter to the query ... can I? I wouldn't think that would work.
Susie
Kansas