Get subform value

[Tom123456]

Hello, lots of questions today.
I have a checkbox in a form. The form also contains a button that generates a report. The report contain a subform that has a textbox called Price. How do I change the color of the text, Am I on the right way??

(chkColor is a checkbox)

On the On open event in the report, this code runs:

If (Forms!GenerateReportForm!chkColor = True) Then
TheSubForm!Price.ForeColor = vbGreen
End If



- Tom

 

[guitardave78]

yep that should work!
try if chkcolor = true then
or if that dont work chkcolor =-1

 

[Tom123456]

Thanks for your answer GuitarDave78 But the question was (my fault) how do I set the color of the text, in other words how do i access the textfield and set Forecolor to green?

- Tom

 

[guitardave78]

oh yeah formname!textcontrol!forecolor = vbgreen

 

[guitardave78]

sorry here it is
Forms!subform.text_control_name.ForeColor = vbGreen

 

[Tom123456]

It doesn´t work, Error 2455. I will try to translate the error message into english: "The expression has a failure to refer to the property of Form/Report"

- Tom

 

[guitardave78]

try
Forms!mainform.subform.text_control_name.ForeColor = vbGreen

 

[guitardave78]

try
Forms!mainform!subform!text_control_name.ForeColor = vbGreen

 

[Tom123456]

can the problem be that the mainform is a report?

- Tom

 

[guitardave78]

yes

 

[Tom123456]

can It be solved?

- Tom

 

[guitardave78]

working on it mate, may be 2moro though