Highlight records used on continuous form

Here is the Conditional Formatting screen

Here is the Access Archon article and sample database

bwestly:
Try the download at this link - it can be utilized for continuous form as well:

http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=375&SID=a4cz7bbz4d198ae88ccz5d8zze7ff21d

Neat samples here as well:
http://www.lebans.com/conditionalformatting.htm

JeffCoachman

All these samples are really cool, but I can't seem to get them to work with what I"m doing.  I made the txtBackfill box around my controls, but when I press my OK command, all of the rows change.  
When I click on OK it writes the information back to my form using:
sql = sql & " WHERE (((RepairScopes.scope_id)=" & Me!Scope_ID & "))"
Therefore, I thought I could use these 2 controls to change txtBackfill as well but only for that row.  
I'm going to try adding a tickbox to the row and see if I can follow bobby6055's click14 example.  

For my example, the two controls being matched have to be as follows:  one is on the CF record (in the Detail section; and the other is in the form header, usually a combo box record selector.  You can see how this works in the sample database in the zip I attached earlier.

Yes, all the examples presented here will work fine, you just have to make sure you change all the object names to match yours.

I think where my problem lies is that I have stacked subforms and I need the popup to compare a field to the form before.  
i.e.  Parent  frmSpec
       Subform  frmComponents
       Subform  frmScope
       Popup form  frmrepairscopepopup

When I pick an item from the popup it populates frmScope.  If that item is already on frmScope it comes back with a message to tell me that it's already there.  The users ALSO want to have the continuous form highlight that they have already used this item.  
I'm attaching the code I use to tell it that the item already exists in case it helps.

Private Sub cmdOkay_Click()
Dim sql As String
 
If DCount("quote_id", "qryScopesUsed", "[scope_id]=" & Me.Scope_ID & "") > 0 Then
 
      MsgBox "This scope has already been used. Any changes need to be done on the main form."
          
 Else
 
sql = "INSERT INTO spec_scopes ( componentid,Eng_id, Part_ID, Scope, Insp_Inst, Photo_Rqd, Criteria, Report_Results, Work_Instruction, Cost, Margin, scope_ID)"
sql = sql & " SELECT '" & Forms!frmSpec!frmComponent.Form!RecID & "', RepairScopes.Eng_id, RepairScopes.Part_id, RepairScopes.Scope, RepairScopes.Insp_Inst, RepairScopes.Photo_Rqd, RepairScopes.Criteria, RepairScopes.Report_Results, RepairScopes.Scope, RepairScopes.Cost, RepairScopes.Margin, RepairScopes.Scope_id"
sql = sql & " FROM RepairScopes"
sql = sql & " WHERE ((RepairScopes.scope_id)=" & Me!Scope_ID & ")"
DoCmd.RunSQL sql
 
 End If
 
End Sub

                                              

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:

I got it working now.  I got the final "key" from Bytes.com.  

I followed Helen's instructions which then worked to highlight the current record I was on, but not records that were already used.  I tied my qryScopesUsed to my Form Source and then bound the txtScope_ID that Helen had instructed me to put on the header. Then I put the [scope_id] = [txtscope_id] on the Form_Current and Form_Open.  It then highlighted only the records that had been used.  When I click on an used record, it highlights that one as well.

Here is what Bytes.com instructed:

1. The control to be conditionally formatted on the continuous form must be bound to a field in the table. If it is unbound, bind it by adding a field to your table for this purpose, or you will continue to show red for all records like you do now..
2. Place the subform in design view
3. Highlight the control that will be conditionally formatted.
4. Go to command menu and select Format>Conditiional Formatting
5. for condition1 first textbox select: Expression is
6 Second texbox enter" Your Conditional expression
7. preview of format textbox: select the red background color that you want formatted control to be when condition is met
8. Click ok button and test.  

Thank you, everyone for your help.