Open Last form

[Bob]

Is it possible to open the forms showing the last form on opening...Thanks
Bob
--







..........Jenny Vance

 

[Allen Browne]

What is "last form"?

Is this:
- the form whose name is closest the then end of the alphabet?
- whichever form this user had open last?
- whatever form any user had open last?

Or did you mean that when the user opens a form, you want to display
whatever record thay had open last time they used that form?

For any of those cases, you will need to use the Unloade event of the form
to store the value in a table. Then DLookup() that value and use it to open
the desired form (when the application starts?) or to go to that record (in
the Load event of the form.)

There's an example of saving the value in a table and using it again later
in this article:
Return to the same record next time form is opened
at:
http://allenbrowne.com/ser-18.html

 

[Bob]

Sorry Allen, To show the last record in that form , last being last Record
Number.......Thanks Bob