Reference text control on tab contol page "Tom" <Tom[ at ]nospam.co.uk> 12/10/2008 11:07:30 AM Going round in a circle on this one so any advice/suggestions would be appreciated. Am using Access 2003. I have a form - frmBooks - on which there is a Tab control. On one of pages of that Tab Control I have an embedded subform and a text box. From that subform I have a cmdButton which on click I want to pass the value from a text box on that subform to a text box on the same page of the Tab Control. I thought that: Forms!frmBooks![TabCtl1].Pages![Topic]![Category] = Me![Category] would do that but I am geting an error msg this method is not supported. What referencing should I be using? TIA Tom

Re: Reference text control on tab contol page "Allen Browne" <AllenBrowne[ at ]SeeSig.Invalid> 12/10/2008 12:50:29 PM Omit the tab control and page name, so just: Forms!frmBooks![Category] = ... Or even: Me.Parent!Category = ... -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Tom" <Tom[ at ]nospam.co.uk> wrote in message news:OdJcAerWJHA.5272[ at ]TK2MSFTNGP04.phx.gbl... [Quoted Text] > Going round in a circle on this one so any advice/suggestions would be > appreciated. > > Am using Access 2003. I have a form - frmBooks - on which there is a Tab > control. On one of pages of that Tab Control I have an embedded subform > and a text box. > > From that subform I have a cmdButton which on click I want to pass the > value from a text box on that subform to a text box on the same page of > the Tab Control. > > I thought that: Forms!frmBooks![TabCtl1].Pages![Topic]![Category] = > Me![Category] would do that but I am geting an error msg this method is > not supported. > > What referencing should I be using?