How can I fit your suggestion

  • Thread starter Thread starter Frank Situmorang
  • Start date Start date
F

Frank Situmorang

Hello Duane I have not resolved the problem, my question is how can I fit your sugegestion below
Then your txt0 - txt4 would have values like:
=Year(TahunPel())
=Year(TahunPel())-1
=Year(TahunPel())-2
=Year(TahunPel())-3
=Year(TahunPel())-4


Should I put addtional calculated field in the mainreport query and in the subreport query?

TahunPel means Year of Service, Is this what you mean as the Year?, and how can we pass the combo box value chosed into this query. Because when I tried it it promps us to fill in the year eventhough I have chosen it in the combo box.

Thanks for your help

Frank


Submitted via EggHeadCafe - Software Developer Portal of Choice
Cool Features of Visual Basic 6.0 Objects!
http://www.eggheadcafe.com/tutorial...4-8c081a7d2976/cool-features-of-visual-b.aspx
 
You want to have the text boxes calculate the value included in the
subreport's record source. I believe you now have the actual year (TahunPel)
with values like 2009, 2008, ... in the subreport's record source. Assuming
you are selecting the final year from a combo box [cboYear] on the form
[frmRptSlct] then your text boxes should have control sources like:
=Forms!frmRptSlct!cboYear
=Forms!frmRptSlct!cboYear-1
=Forms!frmRptSlct!cboYear-2
=Forms!frmRptSlct!cboYear-3
=Forms!frmRptSlct!cboYear-4
 
Back
Top