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)
 

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

Similar Threads

Multiple subforms 0
DateDiff issue 7
Subforms not picking up the date from main form Access 02/03 3
Datediff on form and subform 6
Specify date criteria for subform data 11
subform based on external SQL won't requery 1
showing a subform based on the main form 5
New record in subform 2

Back
Top