Expression builder problem

[JTQ911]

Hi. I am having difficulty with mathematical expression builder. In "Form 1" i have text boxes 47 and 61 which store values in a table. In "Form 2" I have to perform a calculation using these two text box values. I want it when you open form2, once you have put in the values in teh previous form, the calculation is performed. Here is what I have, and i get an error message #Name? when i try to do it.

(-10)* Log ( (Forms![400um panda form 1]![Text47])/( Forms![400um panda form 1]![Text61]) )

Please help, am i doing it wrong or can i not do this?

Regards, Jim

 

[neileg]

Access returns the #NAME error when it can't find an object in the expression.This means it can't find [Text47] or [Text61]. Is Form1 still open when this expression executes, since Access can't see controls on a closed form?

 

[JTQ911]

No, form 1 is not still open, users enter information about a product page by page as they build the product...... is there any other way to get around this......can i use a query to calculate log([Text61]/[Text47]) and then use DLookUp or something like that, i've been searchin this forum tryin to find something similar but im still confused

 

[neileg]

If Form1 is closed then the values in these text boxes will need to be saved somewhere. Usually it is best to store these in a table and then base your expression on the table, or more likely, a query based on the table.

Depeneding on how many 'pages' you need, you could used one form with tabs instead of a series of individual forms.

 

[JTQ911]

neileg, I am a newbie, I think what you've just suggested would be perfect for what I have to do, at least it sounds like it. How do I create one form wtih tabs?

 

[JTQ911]

also, im going to try it now, but the values in form 1 are saved in a table.....let me try that as well... but im really interested in the multiple tabs idea....because i have so many forms that seem slike it would clean up the database as well

 

[JTQ911]

building the expression referencing the table, not the forms still gives me the #Name?

=10*Log([Sensing Coil 2-14]![maxPIN]/[Sensing Coil 2-14]![maxPOUT])

 

[neileg]

Don't use them much but Access help is OK on the subject. Search for Form Tab Control.