How to know last opened form ?

[javiernews via AccessMonster.com]

Is is possible to know which was the last opened form or report ??

Thank you
Javier

 

[Alex Dybenko]

Hi,
perhaps this can work:
forms(forms.Count-1).Name

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

 

[Arvin Meyer [MVP]]

Alex is correct, if the form or report is still open, but you need to add a
table with a timestamp field that each form and report writes to upon
opening to know which is the last opened, if the last one is closed after it
is opened. Then just query the table for the highest value.

Select TOP 1 MyField From MyTable Order By MyField Desc;

 

[javiernews via AccessMonster.com]

Thank You Alex & Arvin !!

I got it !!

Javier