Referencing a row Textbox inside subform

[rkruis]

I have a loop going through each record, and comparing different values. In some cases I need to change the background color of just one text box.

How do I reference that rows textbox? I thought I could use an index, but cannot find it. Like: Form.Row(i) or
Me.subfrm_import_solidworks_detail.Form.Controls!nPartNumber.BackColor = vbRed

    
Set Me!subfrm_import_solidworks_detail.Form.Recordset = rsSW    
    i = 0
    If Not (rsSW.EOF And rsSW.BOF) Then
        rsSW.MoveFirst
        Do Until rsSW.EOF = True
        
            If IsNull(rsSW.Fields("[PART NUMBER]").value) Then
                gImportHasErros = True
                
' This changes all rows, I want only the current rows, textbox
                Me.subfrm_import_solidworks_detail.Form.Controls!nPartNumber.BackColor = vbRed
            End If
            
            'Move to the next record. Don't ever forget to do this.
            rsSW.MoveNext
            i = i + 1
        Loop
    Else
      ' MsgBox "There are no records in the recordset."
    End If

ex.png

[rkruis]

It looks like this must be done using Conditional Formatting.

[OBP]

Forms in Continuous mode can't change just one record's field using VBA, it changes all of them, a major glitch in MA Acceess programming. It is fine for forms in Single Form mode.
There is a roundabout method to do so for continuous mode, but it hardly seems worth the effort when as you say you can use conditional formatting.
If you really wanted to try the VBA method I might be able to find it for you, but I think it may only show up when you are on the record, unlike conditional formatting.

[rkruis]

No worries - I am OK with using conditional formatting. I just had to make some minor changes in the SQL, which ended up being a little cleaner.