Greyowlsl
Mlak Mlak
- Local time
- Today, 16:48
- Joined
- Oct 4, 2006
- Messages
- 206
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.
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.