Adding form textbox to subform textbox

  • Thread starter tomanddani via AccessMonster.com
  • Start date
T

tomanddani via AccessMonster.com

Hi, I have a form named frmBusiness which has a subform named
frmInspectionsSub. Each business can have several inspections (One to Many).
I would like to add a number in frmBusiness's textbox named "InspectionCycle"
to a textbox in frmInspectionsSub named "InspectionDate" which contains a
date. I would like to display this in a textbox on frmBusiness. I need to
have the "InspectionCycle" add to the year in "InspectionDate". I also need
the InspectionDate that it adds to be the last or largest date of that record,
(not of the entire domain just of that business).
This is what I have in the textbox and I know it is not even close.
=DateAdd("yyyy",[InspectionCycle],(Max([frmInspectionsSub].[Form]!
[InspectionDate])))

Please help,
Tom
 

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

Top