How do I get the last form to open?

[kamic]

Access 2000 - when the form is opened it goes to the first
one. How do I make the last completed form open first???

 

[Wendy]

add this event procedure to the "on load" event:
DoCmd.GoToRecord , , acLast

good luck,
Wendy

 

[Howard Brody]

It sounds like you're talking about the records the form displays, not forms themselves. In the OnOpen event, you can set a form to go to a specific record (new, first, last, etc) using VBA code or a macro. The problem is when the table the form is bound to has a key or index; the table will resort by the index(es) every time it opens ... which means the last record entered will probably not be the last record in the table anymore

I get around this by using filters and lookups. I have ComboBoxes where the user selects the record(s) they want to view and then the form filters by their selection

Hope this helps

Howard Brod


----- kamic wrote: ----

Access 2000 - when the form is opened it goes to the first
one. How do I make the last completed form open first??