change the backcolor of subform in the form

ranen

pinoy 'to
Local time
Today, 06:58
Joined
Jun 14, 2005
Messages
29
I do have a form wth a subform, i tried to change the backcolor if its locked. when i load the form the textbox in the form change its color but in the subform it doesn't...I just need help for this one but i will continue to figure it out. thanx a lot :confused:
 
I do not understand the question so we can start with two guesses…

From the parent: -
Me.ctlSubform.Form.Section(acDetail).BackColor = IIf(Me.ctlSubform.Locked, vbRed, vbWhite)

From the Child: -
Me.Section(acDetail).BackColor = IIf(Me.Parent.ctlSubform.Locked, vbRed, vbWhite)

To remove the guessing we would have to know precisely what you are attempting.

Regards,
Chris.
 

Users who are viewing this thread

Back
Top Bottom