 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Database Design / May 2005have autonumber set. How do I set as default entry for form?
Not sure what happened. Was set to go right to new record entry with autonumber when opening form. Now it opens to the very first record in database and you have to got to end to get new record entry. How can I change this back to have the new record entry as the default view? Thanks Set the Data Entry property of the form to Yes.  SignatureLynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html > Not sure what happened. Was set to go right to new record entry with > autonumber when opening form. [quoted text clipped - 4 lines] > view? > Thanks Thanks. Worked. Guess it was changed accidently. > Set the Data Entry property of the form to Yes. > [quoted text clipped - 6 lines] > > view? > > Thanks Hmm. When set to that, now I cannot cycle thru exisitng records as well. Allow edits, and additions is enabled as well. > Set the Data Entry property of the form to Yes. > [quoted text clipped - 6 lines] > > view? > > Thanks The add the following to the Open event of your form Private Sub Form_Open(Cancel As Integer) DoCmd.GoToRecord , , acNewRec End Sub SignatureLynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html > Hmm. When set to that, now I cannot cycle thru exisitng records as well. > Allow edits, and additions is enabled as well. [quoted text clipped - 10 lines] >> > view? >> > Thanks >Hmm. When set to that, now I cannot cycle thru exisitng records as well. >Allow edits, and additions is enabled as well. I don't like Data Entry mode for this very reason. Sometimes you want to default to the new record but still have the ability to go back. Try putting code in the Form's Activate event: DoCmd.GoToRecord acNewRecord When you open the form, or navigate back to it from another form, this will go to the new record. John W. Vinson[MVP] |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.