How do I get the last form to open?

  • Thread starter Thread starter kamic
  • Start date Start date
K

kamic

Access 2000 - when the form is opened it goes to the first
one. How do I make the last completed form open first???
 
add this event procedure to the "on load" event:
DoCmd.GoToRecord , , acLast

good luck,
Wendy
 
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??
 
Back
Top