[MS_AccessPros] Open Form and goto new record

 

I have a form that is a simple list: Code and Description. 

In the form properties/ default view I am opening it as a 'Continuous Forms'.

I have the following in VBA:

Private Sub Form_Open(Cancel As Integer)

DoCmd.GoToRecord , , acNewRec

End Sub

This bring me to a new record when the form open, which is what I want.

Question: the form is a few inches high, and the new record appears all the way on top of the form and empty space below it. 

Can I have the new record appear towards the bottom of the form and see some of the exsisisting  data in the space above the new record? As of now I need to scroll up to see the records.

Thanks for all your advice.

Sarah

__._,_.___

---

Posted by: sarahk@schemesoftware.com

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (1)

Visit Your Group

• New Members 3

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___