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]