Professional Web Applications Themes

field position when going to the next record - Microsoft Access

Hi I have created a form. In the form when I go to the next record with the navigation buttons it takes me to the same field my cursor was on veruss going to the top of the form. How do I change this to go to the top of the form?...

  1. #1

    Default field position when going to the next record

    Hi I have created a form. In the form when I go to the
    next record with the navigation buttons it takes me to the
    same field my cursor was on veruss going to the top of the
    form. How do I change this to go to the top of the form?
    Asha Guest

  2. #2

    Default Re: field position when going to the next record

    I think I did what you wanted.

    select form -> go to properities -> go to events ->
    oncurrent type in [IngrdCode].SetFocus

    When I do this, I get en error saying the macro could not
    be found. I guess I am doing something wrong. The access
    doation for this s.

    Thanks for your help. [/ref]
    the [/ref]
    the [/ref]
    form? 
    Asha Guest

  3. #3

    Default Re: field position when going to the next record

    In On Current event line, Select [Event Procedure]
    Click on the three dots at the end of the box
    I window will open up with the cursor between two lines

    Private Sub Form_Current()
    <CURSOR should be here>
    End Sub


    NOW, enter the code that Fred suggested between the two lines.

    Asha wrote: [/ref]
    > the [/ref]
    > the [/ref]
    > form? [/ref]
    John Guest

Similar Threads

  1. Compare record field with another record field of samerecordset
    By WolfShade_2k in forum Coldfusion - Advanced Techniques
    Replies: 3
    Last Post: May 12th, 02:42 PM
  2. Displaying only a part of a record field
    By neilorourker in forum Coldfusion - Advanced Techniques
    Replies: 6
    Last Post: April 4th, 08:24 PM
  3. Retrieving a field from the NEW record
    By Eric E in forum PostgreSQL / PGSQL
    Replies: 3
    Last Post: January 19th, 04:54 PM
  4. Position of line in field
    By Lery webforumsuser@macromedia.com in forum Macromedia Director Lingo
    Replies: 1
    Last Post: October 13th, 02:17 PM
  5. Fill a field from the previous record
    By Bruce Rodtnick in forum Microsoft Access
    Replies: 3
    Last Post: August 1st, 11:11 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139