Textbox Control Source (1 Viewer)

[bbulla]

For some reason I can't get this to work:

I have a form, with a tab control on it. Each tab has a subform to display data. One tab is meant to be a summary tab of the rest, so I want to pull data from certain controls on each of the other tabs to display on the Summary tab.

If I set the ControlSource to Forms!subfrmLABOUR!txtTotalHours.Value the control just displays #Name?

I assume that means it can't reference the ControlSource. Is it just a syntax thing? I've tried various methods, but no luck.

Thanks,

 

[RuralGuy]

See if this link helps: http://access.mvps.org/access/forms/frm0031.htm

 

[bbulla]

Still no luck: =me!subfrmLABOUR.Form!txtTotalHours.Value

gives me the same error as before.

The strange thing is that if I create a button on the main form and have a Click event like this:

msgbox Me!subfrmLABOUR.Form!txtTotalHours.Value

it works!! Is there a property of the text box that I need to change??

 

[RuralGuy]

Are you attempting to display this information on yet another SubForm on that last tab? If so then it MIGHT be easier to go through the Forms collection.
Forms.YOURFORMNAME.subfrmLABOUR.Form!txtTotalHours.Value

 

[bbulla]

Ah.....your a genius! I guess since I am using a tab control, I needed to reference the main form first (not 'me'), and then work my way back down to the subform.

Thanks for your help!

 

[RuralGuy]

You're certainly welcome but what you had should have worked. Ah well, as another helper likes to say: There is more than one way to skin a cat!

 

[Galaxiom]

You were referring to a different subform on the same main form.

Me.Parent!subfrmLABOUR.Form!txtTotalHours