 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / July 2008Back to the beginning of the form
How do I get the cursor to start at the beginning of the form each and every time after going to the next (or another) record? Open form in design view and view Tab Order. Arrange tab so that the object you want as first is at top of list.  SignatureKARL DEWEY Build a little - Test a little > How do I get the cursor to start at the beginning of the form each and every > time after going to the next (or another) record? Thank you - but the tab order is fine. What I mean is: if I am in, say, the 5th field of a record on a form, and then I go to the next record, the cursor remains on the 5th field. I want it to start on the 1st field in the tab order each time. Does that make sense? > Open form in design view and view Tab Order. Arrange tab so that the object > you want as first is at top of list. > > > How do I get the cursor to start at the beginning of the form each and every > > time after going to the next (or another) record? put this code on the form Current event: '~~~~~~~~~~~~~~ Private Sub Form_Current() On Error Resume Next Me.controlname.SetFocus End Sub '~~~~~~~~~~~~~~ WHERE controlname is the name of the control you want to set the focus to Warm Regards, Crystal remote programming and training Access Basics 8-part free tutorial that covers essentials in Access http://www.AccessMVP.com/strive4peace * (: have an awesome day :) * > Thank you - but the tab order is fine. What I mean is: if I am in, say, the > 5th field of a record on a form, and then I go to the next record, the cursor [quoted text clipped - 6 lines] >>> How do I get the cursor to start at the beginning of the form each and every >>> time after going to the next (or another) record? > Thank you - but the tab order is fine. What I mean is: if I am in, > say, the [quoted text clipped - 3 lines] > tab > order each time. Does that make sense? You can add an OnCurrent event procedure to the form to set the focus to your first control: Private Sub Form_Current() Me.[NameOfFirstControl].SetFocus End Sub Open form in design view and go to the events tab of the form property sheet. Select [event procedure] from the OnCurrent dropdown list, and paste the above code into the code window that appears when you click the [...] code builder button. SignatureClif Still learning Access 2003 >> Open form in design view and view Tab Order. Arrange tab so that the >> object [quoted text clipped - 3 lines] >> > and every >> > time after going to the next (or another) record? SignatureClif Still learning Access 2003 Thank you. That did it. > > Thank you - but the tab order is fine. What I mean is: if I am in, > > say, the [quoted text clipped - 23 lines] > >> > and every > >> > time after going to the next (or another) record? > Thank you. That did it. You're welcome. I hope you took note of Crystal's reply ... hers was better than mine. <grin> (error handling, *and* a link to excellent reference material!) SignatureClif Still learning Access 2003 >> > Thank you - but the tab order is fine. What I mean is: if I am in, >> > say, the [quoted text clipped - 29 lines] >> >> > and every >> >> > time after going to the next (or another) record? SignatureClif Still learning Access 2003 thank you, Cliff ;) Warm Regards, Crystal remote programming and training Access Basics 8-part free tutorial that covers essentials in Access http://www.AccessMVP.com/strive4peace * (: have an awesome day :) * >> Thank you. That did it. > [quoted text clipped - 3 lines] > <grin> > (error handling, *and* a link to excellent reference material!) |
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.