conditional formatting rules manager for access 2010

[June7]

A query that can pull the records for appending to temp table should be able to serve in place of the table. I don't see any reason to write to table. Just use the query that selects the records. The temp table or query could be included in form RecordSource by joining on common identifier field (ProbNum?) - join type "Include all records from {table} and only those from {temptable/query} that match. Then the Conditional Formatting expression can reference the ProbNum field from query - if it Is Not Null then set textbox color.

So is 'work order number' synonymous with 'ProbNum'?

[Paintballlovr]

Ok, we're finally working. Here is what I ended up with for the final code: DLookUp("ProbNum","tblTEMP_UPDATED_ISSUES_NOT_RCTE AM","ProbNum=" & [ID]). Thanks for your assistance, this will be a valuable tool in helping to determine which work orders we look at first!

Sorry, I didn't refresh to notice that you had replied before this. sorry about switching the terminology half way through, but yes, work order number and probnum were the same thing.

[June7]

What do you think about comments on not needing temp table and joining with query to avoid DLookup?

[Paintballlovr]

That's definitely the way to go. I've already released the current version, but I'm going to go back and switch it out in the next couple of days. Thanks again!