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

Selasa, 27 Oktober 2015

Re: [MS_AccessPros] Open Form and goto new record

Crystal. Exactly what I was looking for.I made a little loop so it displays a few records and then goes to the new record.

Thank You

Sarah

---In MS_Access_Professionals@yahoogroups.com, <strive4peace2008@...> wrote :

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@... [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