Selecting objects in a subform (1 Viewer)

[Greyowlsl]

Hi,
Ide like to know how chnage the color of a text box on a subform when selecting an option in a combo box. This is what i have so far, but it dosen't seem to work. I have also looked at http://access.mvps.org/access/forms/frm0031.htm but it hasn't helped me.

If Me.cboTypeOfService = "Warranty Repair" Then
Me.[Service Record subform].txtTotalLatronics.ForeColor = vbWhite
Else: Me.cboTypeOfService.SetFocus
End If

The error seems to be that it thinks Service record subform is an object on the main form, and detecting it as a subform control.

Thanks for your time and help.
Greyowl.

 

[John Big Booty]

This link should help you get the correct syntax for revering to subforms their properties and controls.