pull data from other form for calculation in subform

S

sargum

Hi,

I have an unbound text box control in a subform called "ml/sec/window".
The subform contains the fields that contain the "ml" and "sec" (i.e,
Volume and Time fields) values that I need to perform the calculation.
However, the subform does not contain the window info and I need to
pull that data from a completely different form. To solve this
problem, I could just add a field called "# of windows" to the subform
but it would be repetitive for the user to have to input this info
every time.

I have tried the following in Control Source with no luck:

=[Volume]/[Time]/Forms![Hydraulic Permeability]![# windows]

but I get a "Name?" error showing up as a return on the field.

Can anyone help me figure out how to get a value from a parent form to
complete my calculation? Note that as a test I did make sure that when
the control source just equals[Volume]/[Time], I do get a value so the
error really is coming from the second division clause of my
calculation. Also note that I have a relational database with parent
forms and subforms linked together by unique ID's.

Thanks in advance.

S
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculation Question 10
Populate main form from subform record 0
MS Access 2007: Calculated field based on subform: 1
Sum error on continous subform 4
Subform Subtotal 1
Datediff on form and subform 6
Transfer A value from a subform to the form 2
Delay in getting subform total to calculate 2

Top