Find data on main form from subform code

[mattc66 via AccessMonster.com]

Hi All,

I have some code in my subform. I am would like to run an if statement like
below. If on the main form a check box is checked then... However my syntax
is wrong and the code cant see my main form object. Can anyone help.

If Forms![frmPO_Lookup].Form!ckref = True Then
....
Thanks

 

[boblarson]

Most likely your form (frmPO_Lookup) is actually in a subform container
control that is NOT named frmPO_Lookup. When using code to refer to
subforms, you need to refer to the subform CONTAINER name, not the subform
name (although it can be the subform name if the container has the same name).

See here for more explanation about subforms:

http://www.btabdevelopment.com/main...rhowtoreferencesubforms/tabid/76/Default.aspx

--
Bob Larson

Free Tutorials and Samples at http://www.btabdevelopment.com

__________________________________

 

[Beetle]

If the code is in the subform and the ckref control is on the main form;

If Me.Parent!ckref = True Then

 

[boblarson]

Good point - missed that one
--
Bob Larson

Free Tutorials and Samples at http://www.btabdevelopment.com

__________________________________

If the code is in the subform and the ckref control is on the main form;

If Me.Parent!ckref = True Then
--
_________

Sean Bailey

Hi All,

I have some code in my subform. I am would like to run an if statement like
below. If on the main form a check box is checked then... However my syntax
is wrong and the code cant see my main form object. Can anyone help.

If Forms![frmPO_Lookup].Form!ckref = True Then
....
Thanks