Date Updated Last

G

GregInOz

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
 
S

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

GregInOz

Fantastic!

Thanks Steve.


Steve Schapel said:
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
Click to expand...
Click to expand...
 
Top