Compare Field in Subform to Field in Another Subform

[PSSMargaret]

Hi all,

Hoping to get some direction. I have a main form with two separate subforms. I'd like the font of the "Title" field in all of the records in Subform1 to turn red if they don't match the "Title" field in any of the records in Subform2.

I'm open to conditional formatting or VBA. Any directions would be greatly appreciated.

[June7]

Why do you have two subforms with same structure?

Conditional formatting is the only way to do conditional display on Continuous or Datasheet form.

Use DCount() in the conditional format expression. Or call a custom function in the expression.

[PSSMargaret]

One of the subforms displays the baselines and other subform displays the actual data. I want the performance data to highlight if someone has entered a dataset with a title that has not been defined in the baselines. Can you give me an idea how to layout the DCount expression?

[June7]

DCount("*", "tablename", "[Title]='" & [Title] & "'")>0

[PSSMargaret]

Well, I'd like to tell you that I've been successful, but I've really been struggling to implement this and hope you are willing to help a little further. Each of the subforms have different IDs (Subform1 is PerformID and Subform2 is IMID). Each of the forms contain the Title field. Also, doesn't your suggestion (below) indicate greater than in stead of indicating that Subform2 doesn't list the Title that is listed in Subform1? Or maybe I'm too tired. Any help is appreciated.

DCount("*", "tablename", "[Title]='" & [Title] & "'")>0

[June7]

Okay, highlight if expression = 0.

What is your table name?

Don't know what relevance the IDs have to matching on Title.

[PSSMargaret]

The mainform data source is qryInd
Subform1 data source is qryPD
Subform2 data source is qryJctBase - many-to-many relationship

I've used Dcount before in VBA to inform the User if they selected a choice that's already been selected and it required IDs because they involved with a table that was a many-to-many relationship.

[June7]

You can use whatever fields you want. As long as you pass the correct parameter to the expression.

You said match on Title fields so that is what my example uses.