show datediff on subform, between 2 dates on separate form?

  • Thread starter Thread starter Matt
  • Start date Start date
M

Matt

Probably a simple solution.... I have two tables/subforms. Table/subform A
contains two dates (datereceived, date reviewed). Subform B is where I would
like the DateDiff between these two dates to appear. Thoughts? Im having a
senior moment...
 
Matt said:
Probably a simple solution.... I have two tables/subforms. Table/subform
A
contains two dates (datereceived, date reviewed). Subform B is where I
would
like the DateDiff between these two dates to appear. Thoughts? Im having
a
senior moment...
Click to expand...

Presuming subforms A and B are embedded in a single main form, the syntax
for subform A's AfterUpdate event, would be:

Me.Parent.SubformBcontrolName.Form.DateControlName = DateDiff("d", [date
reviewed], datereceived)

(all on one line of course)
 
Back
Top