ACCESS FEED: Re: [MS_AccessPros] Open Form and goto new record

Senin, 26 Oktober 2015

Re: [MS_AccessPros] Open Form and goto new record

Hi Sarah,

New records are always entered on the bottom. Sometimes what I do is create unbound boxes on top for adding new information.

Another thing you can do after going to a new record, is go to the previous record and then next record to show one record above. For instance:

   DoCmd.GoToRecord , , acNewRec
   DoCmd.RunCommand acCmdRecordsGoToPrevious
   DoCmd.RunCommand acCmdRecordsGoToNext

make sure you have records above it though.

warm regards,
crystal

free Contact Template for Access including Project Management and Common Business Needs
http://msaccessgurus.com/Contacts.htm

~ have an awesome day ~

On 10/26/2015 1:45 PM, sarahk@schemesoftware.com [MS_Access_Professionals] wrote:

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