Dateadd question

M

MarkH

I am trying to add a date from a nested subform to a date
on the main form. The subform is nested in a one-to-many
relationship with the main form. Naturally several dates
can exist in the subform...I want to add only the maximum
date value in the subform to the date in the main form.
Is this possible? Thanks for any ideas.
 
C

Chaplain Doug

Try DMax("[date field name]",Forms![main form name]!
[subform name].Form.recordsource)
 

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