last note entry

J

JohnE

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
 
D

Donnie Keith via AccessMonster.com

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
 
J

JohnE

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
 
F

Fons Ponsioen

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
 
H

HelixxileH

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?
 
Top