Conditional Formatting question?

[skeeter63]

First, let me say that I know only the basics in Access 2003 and use mostly the provided GUI controls to accomplish my tasks. Second, I have no previous coding experience at all! Thanks for being here and helping those of us who lack the knowledge and skills!!!

Background:
Tables-
1. Jobs
(a)JobsID (PK)
(b)JobsCompleted (Checkbox)
2. Job Tasks
(a)JobTaskID (PK)
3. Job Tasks Assigned to Jobs (Linked Table)
Self Explanatory

I have a main form that allows you to select the job. i have a subform that shows the Job Tasks associated to that Job. I built a query to search for only Job Tasks that are associated with completed Jobs and it works fine. I place a second subform displaying only the JobTaskID field from the query results in datasheet view and hide it. Added a conditional format to the first subform (JobTaskID)to change the text color if it was equal to any results from the query in the hidden subform. As you can image, the Access limitation smacked me in the face. It seems to be only looking at the first record and not all the records in the hidden subform. Is there a way to force Access to evaluate all the records? This is driving me crazy! Thanks for any help you can provide...
Lost

[TheSmileyCoder]

Hi and Welcome to Bytes!

While you may find it in-convenient that is the way Access works. You could make code to loop through the recordset attached to the subform but there are smarter ways of doing it.

If you could post the SQL behind the visible subform, Im confident we can work something out.

[skeeter63]

Thank you for the quick response! I'm not sure how to post "the SQL behind the visible subform?" When I opened the DB and tried to view SQL, the option was not available. The Code icon showed nothing as well for the subform. Sorry for being so new at this!

[TheSmileyCoder]

Assuming you know the query window and how to get to it, you should be able to select View->SQL view and then see the SQL syntax of the query. Copy & paste it here.

[jimatqsi]

Have you filled in the Parent/Child linkage on the hidden subform? If you do that, then the hidden subform will ONLY have records that link to the current JobsID. So you won't get extraneous records on that form. You have only to test to see if the JobTaskID on the subform is null or not. If it is not null then there is at least one matching record on that subform.

Jim