apply conditional formating to a query using a check box on a form.

[Plopez05]

I created a form to input permits for new construction sites. I then use a parameter query to locate the permits by date. If I have allready been to look at the job, on the form I put a check box, what I want to do is when I check that box I want to change the color of that record when I run the query, so that at a quick glance I know what has been compleated.

Thanks for the help in advance.

PLop.

 

[Remou]

It seems to me that you need a continuous form based on the query and some conditional formatting to highlight the relevant records.

 

[Plopez05]

I have created this db, but I learn as I go, How would I do what you suggested about using a continuous form then applying conditional formating.

 

[Remou]

Build a form using your query, you can use the Wizard and choose AutoForm: Tabular from the list. Click in the margin to select the row of controls and choose Conditional Formatting from the Format menu. Select Expression Is as Condition 1 and type:
[Name of CheckBox]=True
Into the box and choose a background color. You will find more information on conditional formatting in Help.