Query Calculation Help

  • Thread starter Thread starter K
  • Start date Start date
K

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.
 
On Fri, 24 Oct 2008 05:29:00 -0700, K <K@discussions.microsoft.com>
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
 
Back
Top