Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Apr 2003
    Location
    Kontich, Vlaanderen, Belgium
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Cursor in 1st field on input form (ACC97SR2)

    Hi all,

    I have an input form that I use to input data in my database (quite logical isn't it ?) <img src=/S/blush.gif border=0 alt=blush width=15 height=15> .

    But I do not need to fill in all the fields in each record. When the available data is in the corresponding fields, I hit the next record button (at the bottom of the form) and start inputting the data for the next record. And here comes my question : How do I force the cursor to the first field on the input form ? Because now, I have to point the mouse cursor into the first field on the input form and click before I can start inputting data.

    Does someone has the answer to this ? <img src=/S/confused3.gif border=0 alt=confused3 width=45 height=45>

    MTIA

    Walter

  2. #2
    2 Star Lounger
    Join Date
    Apr 2003
    Location
    Kontich, Vlaanderen, Belgium
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Cursor in 1st field on input form (ACC97SR2)

    Hans,

    Thank you for your prompt reply <img src=/S/thankyou.gif border=0 alt=thankyou width=40 height=15>.
    I just changed my input form accordingly, and things are now as I want them to be.

    Best regards,

    Walter

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Cursor in 1st field on input form (ACC97SR2)

    You can use the On Current event of the form to set focus to the first control:

    Private Sub Form_Current()
    Me.ControlName.SetFocus
    End Sub

    where ControlName must be replaced by the name of the appropriate control. If the name contains spaces or unusual characters, enclose the name in square brackets [ ].

Posting Permissions

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