open at blank record in subforms and tab pages

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
 
A

Al Camp

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unremovable horizontal scroll bar on subform 1
Show record numbers on subforms 1
Subform for data entry only 4
Working with Tabs and Subforms 1
MS Word Page Layout/Break/Margin Issues, help 0
Form/subform navigation 4
Printing a form on a tabcontrol 1
linking and sizing one form inside another 0

Top