Command or Micro to find last modified form

[Huddle]

I could like to create a command button on my form to allow the user to go to the last form that had any data added to it.



Is this possible?

[NTC]

If you have a time stamp field or a field that is incrementing up with each record then it is possible. One must locate the record with the MAX value of that field.

You state the 'last form' rather than the last record. Whether or not a form launches is somewhat of a different issue.

[Huddle]

I do have a logged in date but that may not necessarily be the last record reviewed.

[NTC]

If your question is how to design; then you want to use a timestamp method probably.

If your question is that you have an existing db and is there a way to know which is the last record modified? - then the answer is no in terms of generic vanilla Access; unless that db was customized by the developer to have a timestamp type feature with each record.

hope this helps.

[Huddle]

Thanks anyway