Date Updated Last

[Guest]

Hi All,

I have a subform "Notes" within a main form "ClaimForm" and would like to
create a filed "lastupdate" on "ClaimForm" and later a report that
displays/populates "lastupdate" with the most recent date from the subform
"Notes".

Thanks

GregInOz

 

[Steve Schapel]

Greg,

Do you mean that the Notes subform includes a date field? So each Note
entry has a DateEntered or DateCreated or DateUpdated or whatever? If
so, put an unbound textbox (hidden, probably) in the Header or Footer
section of the subform, with its Control Source set to the equivalent of...
=Max([YourNotesDateField])
Let's say you name this textbox LatestNote. Then, on the main form, put
another unbound textbox, with its Control Source like this...
=[Notes]![LatestNote]
or, as some would have it...
=[Notes].[Form]![LatestNote]

If you don't have a date field in the Notes, then I have missed the
point - please let us have more details.

 

[Guest]

Fantastic!

Thanks Steve.

Greg,

Do you mean that the Notes subform includes a date field? So each Note
entry has a DateEntered or DateCreated or DateUpdated or whatever? If
so, put an unbound textbox (hidden, probably) in the Header or Footer
section of the subform, with its Control Source set to the equivalent of...
=Max([YourNotesDateField])
Let's say you name this textbox LatestNote. Then, on the main form, put
another unbound textbox, with its Control Source like this...
=[Notes]![LatestNote]
or, as some would have it...
=[Notes].[Form]![LatestNote]

If you don't have a date field in the Notes, then I have missed the
point - please let us have more details.

--
Steve Schapel, Microsoft Access MVP

Hi All,

I have a subform "Notes" within a main form "ClaimForm" and would like to
create a filed "lastupdate" on "ClaimForm" and later a report that
displays/populates "lastupdate" with the most recent date from the subform
"Notes".

Thanks

GregInOz