calculated control

[Guest]

I need to make a calulated control that displays my ContractAMT field value
that appears in the subform. No matter what equation I try, I get either a
#Error or a #Name error. What should I do?

 

[Guest]

Have you tried useing the function dialog box to enter your calulated
controls? Are you using an Error Checking Indicator on Controls, the type of
error will display, click options- Error Checking tab- and Check to see that
it is Enabled and that all Form/Report rules are checked, one last check is
Options-Forms/Reports check to ensure that "Use Windows Themed Controls on
Forms" is not checked Click Apply
I hope this helped and I hope this is where you are in the (Forms) process

 

[John Vinson]

I need to make a calulated control that displays my ContractAMT field value
that appears in the subform. No matter what equation I try, I get either a
#Error or a #Name error. What should I do?

Perhaps you could give us a little help?

If the expression is correct you will not get an error message; but
since we don't know anything about the structure of your tables, of
your form, or what you've tried, it's rather hard to advise!

John W. Vinson[MVP]

 

[Guest]

My structure is as follows:
I have a main form with 2 tabs. One tab shows client information; the
second shows contract information and is a subform. Above the tab is the
client name and ID. I need to make a calculated control that adds up the
total countract amount from the subform.

 

[John Vinson]

My structure is as follows:
I have a main form with 2 tabs. One tab shows client information; the
second shows contract information and is a subform. Above the tab is the
client name and ID. I need to make a calculated control that adds up the
total countract amount from the subform.

Again, Rachel... YOU can see your database. We cannot. You're
describing the user iew of the form and what you want to accomplish,
but you are not describing the actual *structure* of the form.

You have a table (with fields whose names we do not know and cannot
see).
You have a form (with a Recordsource you have not told us, and
controls whose names and other properties we cannot see).
You have an expression which doesn't work, and you have not told us
what the expression looks like.

I would love to be able to help, but unless you post some information
ABOUT YOUR ACTUAL FORM I cannot do so.


John W. Vinson[MVP]