Totals text box in tab control?

[Troy]

I have a sub form in a tab control. On the subform I have a subtotals text
box in which I sum the totals. I would like to have a copy of this on that
tab page, but nothing shows up. I have tried using

Forms![Maintenance]![SubTotal]

in the control source. HELP!

Troy

 

[tina]

on the main form's tab control page, in the textbox control's ControlSource
property, try something along these lines

=Forms!MainFormName!SubformCONTROLName!SubformTextboxName

to make sure you're using the name of the subform *control* (not the name of
the subform - sometimes they're different):
1. open the main form in design view.
2. click once on the subform to select it.
3. click on the Other tab in the Properties box, and look at the Name
property.

hth

 

[tina]

btw, if the expression doesn't work, and you're sure that you've got the
form and control names correct, then try this variation:

=Forms!MainFormName!SubformCONTROLName.Form!SubformTextboxName

on the main form's tab control page, in the textbox control's ControlSource
property, try something along these lines

=Forms!MainFormName!SubformCONTROLName!SubformTextboxName

to make sure you're using the name of the subform *control* (not the name of
the subform - sometimes they're different):
1. open the main form in design view.
2. click once on the subform to select it.
3. click on the Other tab in the Properties box, and look at the Name
property.

hth


"Troy" <troy> wrote in message news:[email protected]...

I have a sub form in a tab control. On the subform I have a subtotals text
box in which I sum the totals. I would like to have a copy of this on that
tab page, but nothing shows up. I have tried using

Forms![Maintenance]![SubTotal]

in the control source. HELP!

Troy

 

[Troy]

Tina that didn't work unfortunately. Here are the names of my forms.

main form name: main
subform name: maintenance
tab control name: tab2
text box name: subtotal

btw, if the expression doesn't work, and you're sure that you've got the
form and control names correct, then try this variation:

=Forms!MainFormName!SubformCONTROLName.Form!SubformTextboxName

on the main form's tab control page, in the textbox control's ControlSource
property, try something along these lines

=Forms!MainFormName!SubformCONTROLName!SubformTextboxName

to make sure you're using the name of the subform *control* (not the

name

of
the subform - sometimes they're different):
1. open the main form in design view.
2. click once on the subform to select it.
3. click on the Other tab in the Properties box, and look at the Name
property.

hth


"Troy" <troy> wrote in message news:[email protected]...

I have a sub form in a tab control. On the subform I have a subtotals text
box in which I sum the totals. I would like to have a copy of this on that
tab page, but nothing shows up. I have tried using

Forms![Maintenance]![SubTotal]

in the control source. HELP!

Troy

 

[Troy]

I wasn't paying attention, forgot to sum the totals in the text box I was
referring to!

Thanks Tina!

Tina that didn't work unfortunately. Here are the names of my forms.

main form name: main
subform name: maintenance
tab control name: tab2
text box name: subtotal

btw, if the expression doesn't work, and you're sure that you've got the
form and control names correct, then try this variation:

=Forms!MainFormName!SubformCONTROLName.Form!SubformTextboxName

on the main form's tab control page, in the textbox control's ControlSource
property, try something along these lines

=Forms!MainFormName!SubformCONTROLName!SubformTextboxName

to make sure you're using the name of the subform *control* (not the

name

of
the subform - sometimes they're different):
1. open the main form in design view.
2. click once on the subform to select it.
3. click on the Other tab in the Properties box, and look at the Name
property.

hth


"Troy" <troy> wrote in message I have a sub form in a tab control. On the subform I have a subtotals
text
box in which I sum the totals. I would like to have a copy of this on
that
tab page, but nothing shows up. I have tried using

Forms![Maintenance]![SubTotal]

in the control source. HELP!

Troy