Read control info from other form

[Edwinq]

Hi,
I'd like to read a label on another form.
I thought it would be easy to just read
controls(Forms!form!subform!label1)
gives me an error the control does not exist.

any help would be appreciated.
edwin

 

[pbaldy]

See if this helps:

http://www.mvps.org/access/forms/frm0031.htm

You'd want to read the caption property of a label, I suspect.

 

[Steve R.]

Hi,
I'd like to read a label on another form.
I thought it would be easy to just read
controls(Forms!form!subform!label1)
gives me an error the control does not exist.

any help would be appreciated.
edwin

If I understand your question you have two forms open and want to read the value of a control on one of those forms. Below, may be a partial solution for you. It returns the value contained in the control, not the name of the control. Additionally if it is a label you would need to retrieve the caption property.

SomeValueForm1= Forms("Form2").Controls("text30")

However, if you have a form/subform set-up follow the advice of pbaldy.

 

[boblarson]

Also, labels don't have values. You need to read the .Caption property if you are really dealing with a label.