 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / July 2008cursor position on new record
Sorry for the newbie Q! I need some VERY basic info in the simplest of terms to enable me to have the cursor positioned in the second field regardless of which field it was on the previous record prior to going to "new record". I found reference to "focus" & "onopen" etc but none told me exactly where to enter the info. I'm using Access 2003. Unfortunately most of the tutorials & help articles that I came across don't start from lesson one explaining it in detail. I hope I can get some BASIC help here? Thankyou in advance. Assuming you only want to go to field 2 when you select a new record, In the On Current event of the form put this If Me.NewRecord = True Then [Field 2 Name].SetFocus End If > Sorry for the newbie Q! > I need some VERY basic info in the simplest of terms to enable me to have [quoted text clipped - 7 lines] > I hope I can get some BASIC help here? > Thankyou in advance. Mmmm, that's the bit I sort of already knew. If I go to the form, change it to Design View & then rt click on the top of the form & go to properties I can see on EVENT tab the one that says "On Current". For the life of me I can't paste in what you told me to. I'm just lost........ Help! > Assuming you only want to go to field 2 when you select a new record, > In the On Current event of the form put this [quoted text clipped - 17 lines] >> I hope I can get some BASIC help here? >> Thankyou in advance. Click in the box On Current and a drop down arrow will appear at the right hand side. Click the arrow and select Event procedure. Then click on the elipse (3 dots) at the right of the drop down arrow and this will put you into the code editor for that event. Paste the code in there. Close the code editor and save the form. > Mmmm, that's the bit I sort of already knew. > If I go to the form, change it to Design View & then rt click on the top of [quoted text clipped - 25 lines] > >> I hope I can get some BASIC help here? > >> Thankyou in advance. Thanks Dennis........ I nearly had it. There was some code already in there & I had to paste it in between each existing line. Eventually got it. I actually checked out the Northwood example but they didn't have that "fix" either. Once again, thanks > Click in the box On Current and a drop down arrow will appear at the right > hand side. Click the arrow and select Event procedure. Then click on the [quoted text clipped - 34 lines] >> >> I hope I can get some BASIC help here? >> >> Thankyou in advance. I have been posting for years as BruceM. If you expect to be posting regularly I would prefer that you choose a different screen name in order to avoid confusion. > Mmmm, that's the bit I sort of already knew. > If I go to the form, change it to Design View & then rt click on the top [quoted text clipped - 26 lines] >>> I hope I can get some BASIC help here? >>> Thankyou in advance. |
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.