open at blank record in subforms and tab pages

  • Thread starter Thread starter louise
  • Start date Start date
L

louise

hi

I have 3 tab pages, each with a sub form, i'd like to know how to get
each subform on each tab page to always open at a blank record (but
still allow you to see the other records)

Can anyone help?

Ta

Lou
 
Louise,
In each of the subform's OnOpen events, place this code...
DoCmd.GoToRecord , , acNewRec
Your subforms will open displaying the New record, but you can scroll up to
see that the other records are still there.
 
Back
Top