Query Calculation Help

[K]

Good day, I have a subfrom based on a query called frmDataSub I would like to
have the subform display the number from the main form frmDataMain. Currently
I have the calculation in the subform query EFF:=form!frmDataMain!Efficiency
however it does not display the efficiency field from the main form in the
query. (Actually it is a bunch of boxes...???.. Is this because I cannot pull
the filed from the main form into the query? If not can I code it in VB? If
so how would I do this?

I appreciate your time. Kyle.

 

[Tom van Stiphout]

On Fri, 24 Oct 2008 05:29:00 -0700, K <[email protected]>
wrote:

Your syntax is wrong. It should be:
EFF:=forms!frmDataMain!Efficiency

Or the controlsource of the subform control could be set to
Me.Parent.Efficiency

-Tom.
Microsoft Access MVP