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
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