Selecting objects in a subform

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.
 
This link should help you get the correct syntax for revering to subforms their properties and controls.
 

Users who are viewing this thread

Back
Top Bottom