Mainform Text Box that should copy subTotal in a subform

[Jan T.]

Using WinXP and Access2003 I try to make a Main form with a
subForm. I have looked at Northwind.mdb sample database where
there are a text box that retrieves the OrderSubTotal of the subform.

In Northwind the text box in the main form says
ControllSource=[Orders Subform].[Form]![OrderSubtotal]

When trying to do the same with my forms, I get an error in my text box on
my
Main Form and can't see why? Does anybody have a suggestion?

Thanks for any help with this in advance.

Regards
Jan

 

[Steve]

Open your form in design view. Select the subform control (the border around
your subform). Click on the properties icon in the menu and go to the Other
tab. Look at the name of the control. That name must be in the expression
where it says Orders Subform in the Northwind example. Also select your
subtotal textbox and look at its name. That name must must be in the
expression where it says OrderSubtotal in the Northwind example.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

 

[Jan T.]

Oh, I am sorry. I did that. I used the names from my own forms, and have
checked
the spelling. It still says #Name? in the text box on my Main form?

Jan

Open your form in design view. Select the subform control (the border
around your subform). Click on the properties icon in the menu and go to
the Other tab. Look at the name of the control. That name must be in the
expression where it says Orders Subform in the Northwind example. Also
select your subtotal textbox and look at its name. That name must must be
in the expression where it says OrderSubtotal in the Northwind example.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

Using WinXP and Access2003 I try to make a Main form with a
subForm. I have looked at Northwind.mdb sample database where
there are a text box that retrieves the OrderSubTotal of the subform.

In Northwind the text box in the main form says
ControllSource=[Orders Subform].[Form]![OrderSubtotal]

When trying to do the same with my forms, I get an error in my text box
on my
Main Form and can't see why? Does anybody have a suggestion?

Thanks for any help with this in advance.

Regards
Jan

 

[Steve]

Does the control source of the textbox have:
=[Orders Subform].[Form]![OrderSubtotal]
but with your names?

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

Oh, I am sorry. I did that. I used the names from my own forms, and have
checked
the spelling. It still says #Name? in the text box on my Main form?

Jan

Open your form in design view. Select the subform control (the border
around your subform). Click on the properties icon in the menu and go to
the Other tab. Look at the name of the control. That name must be in the
expression where it says Orders Subform in the Northwind example. Also
select your subtotal textbox and look at its name. That name must must be
in the expression where it says OrderSubtotal in the Northwind example.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

Using WinXP and Access2003 I try to make a Main form with a
subForm. I have looked at Northwind.mdb sample database where
there are a text box that retrieves the OrderSubTotal of the subform.

In Northwind the text box in the main form says
ControllSource=[Orders Subform].[Form]![OrderSubtotal]

When trying to do the same with my forms, I get an error in my text box
on my
Main Form and can't see why? Does anybody have a suggestion?

Thanks for any help with this in advance.

Regards
Jan

 

[Jan T.]

Now it works fine!! Yesss!
First attempt I did. Then discovered a misspelling and thought the
expression tool would help me.
But it did not! Now that I used exactly the same way as the example, that
did the trick.

Thanks a lot.

Jan

Does the control source of the textbox have:
=[Orders Subform].[Form]![OrderSubtotal]
but with your names?

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

Oh, I am sorry. I did that. I used the names from my own forms, and have
checked
the spelling. It still says #Name? in the text box on my Main form?

Jan

Open your form in design view. Select the subform control (the border
around your subform). Click on the properties icon in the menu and go to
the Other tab. Look at the name of the control. That name must be in the
expression where it says Orders Subform in the Northwind example. Also
select your subtotal textbox and look at its name. That name must must
be in the expression where it says OrderSubtotal in the Northwind
example.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)


Using WinXP and Access2003 I try to make a Main form with a
subForm. I have looked at Northwind.mdb sample database where
there are a text box that retrieves the OrderSubTotal of the subform.

In Northwind the text box in the main form says
ControllSource=[Orders Subform].[Form]![OrderSubtotal]

When trying to do the same with my forms, I get an error in my text box
on my
Main Form and can't see why? Does anybody have a suggestion?

Thanks for any help with this in advance.

Regards
Jan

 

[Jan T.]

Another question. Is it possible to Sum a Field in a SubForm and have the
result in a text box in the footer
section, but only summing the records having a special date?

In other words, is it possible to sum orders amount that are not more than
seven days old and exlude the
other records in the subForm and simultaneously also be able to see the rest
of the records in the subForm?

Any answer is very much appretiated. Thanx!

Jan

Now it works fine!! Yesss!
First attempt I did. Then discovered a misspelling and thought the
expression tool would help me.
But it did not! Now that I used exactly the same way as the example, that
did the trick.

Thanks a lot.

Jan

Does the control source of the textbox have:
=[Orders Subform].[Form]![OrderSubtotal]
but with your names?

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

Oh, I am sorry. I did that. I used the names from my own forms, and have
checked
the spelling. It still says #Name? in the text box on my Main form?

Jan


"Steve" <[email protected]> skrev i melding
Open your form in design view. Select the subform control (the border
around your subform). Click on the properties icon in the menu and go
to the Other tab. Look at the name of the control. That name must be in
the expression where it says Orders Subform in the Northwind example.
Also select your subtotal textbox and look at its name. That name must
must be in the expression where it says OrderSubtotal in the Northwind
example.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)


Using WinXP and Access2003 I try to make a Main form with a
subForm. I have looked at Northwind.mdb sample database where
there are a text box that retrieves the OrderSubTotal of the subform.

In Northwind the text box in the main form says
ControllSource=[Orders Subform].[Form]![OrderSubtotal]

When trying to do the same with my forms, I get an error in my text
box on my
Main Form and can't see why? Does anybody have a suggestion?

Thanks for any help with this in advance.

Regards
Jan