REQUERY A TAB text box FROM a SUBFORM text box

[sandman]

As the title suggests I have a subform that is in the tab of a main-form, and I want to requery a text box [ref2] on the tab from a text box in the subform after an entry has been made.

should I use Me.parent.control name.requery or the Forms statement to the control.requery

[Gicu]

Not quite sure what your setup is but the fact that a(ny) control is placed on the form itself on on a tab control which is itself placed on the form makes no difference in how you reference the control.

So if you want to requery a control on the main form (regardless if placed in the header, detail, footer or a tab control on any of those three sections) from a subform placed anywhere on the same form (including on a tab control) you could use

Me.Parent.Form.Controls("txtYourTextBoxToRequery")

[sandman]

Ok. thanks for the reply.

This is what i am using currently Me.Parent.ref2.Requery

What I have seems to work, although I'm not sure it will throw an error at some point. Any comments appreciated.