Totals text box in tab control?

  • Thread starter Thread starter Troy
  • Start date Start date
T

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
 
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
 
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


tina said:
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
Click to expand...
Click to expand...
 
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


tina said:
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


tina said:
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
Click to expand...
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
Click to expand...
Click to expand...
Click to expand...
 
I wasn't paying attention, forgot to sum the totals in the text box I was
referring to!

Thanks Tina!

Troy said:
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


tina said:
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


tina said:
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
Click to expand...
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top