last note entry

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a main form that has a subform in it. The subform is a continuous
form that the user is able to enter notes into on an individual date basis.
My question centers around the report of this info. What I would like to do
is to only have the last entry (or most current) on the report. I remember
doing this several years ago but not able to find it any longer. So, I ask
out to the newsgroup if anyone has done this that can give me a walk thru on
getting the last entry date on the report. Thanks to anyone for assistance.
*** John
 
I think there are two ways.

On the subform On Open Event Procedure put

Docmd.GoToRecord, , acLastRecord

Maybe the best method would be to go to the last record by using an
autonumber and setting the query to descending.

Maybe even a go to last record on open.
Do a search in the help file of MS Access for last modified property

just some ideas, not an expert
 
Donnie, thanks for the response. But, I'm actually looking for putting the
last comment entry on a report rather then having it show in the subform.
That I have no problem in doing. It is on a report in which I am not able to
remember how it is done. Any suggestionss?
*** John
 
Hi John.
The way I would approach ithat is to have a dat stamp on the entry when
entered via your form. Now, in the report use a query for the source of your
entries sorted deescending by date and limit to the top one.
That should get you the info you want.
Hope this helps.
Fons
 
JohnE,
Have you found a solution to your dilemma yet? I too, am looking for a
similar solution; I'm trying to write a query that will find the last entry
for category of many activities so that only the most recent activity for
each category is retrieved (this is a documentation database to prioritize
clerical handling). If you have garnered any wisdom from your search, would
you please enlighten me?
 
Back
Top