Results 1 to 8 of 8
  1. #1
    newtoAccess is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Nov 2009
    Posts
    226

    How do I make a form open and select a specific field?

    I have my main menu open when the file is opened.


    How do I have a specific field selected when the form opens?

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows XP Access 2002
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Use the tab order and make that control the first in the list.

  3. #3
    Simple is offline Novice
    Windows XP Access 2000
    Join Date
    Nov 2009
    Posts
    8
    If you care to reatain look and feel of your form you can use setfocus in the OnOpen event property of the form. I personally think Rurals way is cleaner, but this is another option should you feel like you need to keep your form as is.

  4. #4
    newtoAccess is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Nov 2009
    Posts
    226
    I have the tab order set to 1,
    When the form opens the control turns yellow as it should.
    If I start typing nothing happens, I have to click or tab twice toget the cursor to be flashing in the control box.

    Any suggestions?

  5. #5
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows XP Access 2002
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    When you remove *all* of the code from *all* of the events in that control, does it then work correctly? If so, start putting the code back one event at a time until the problem returns.

  6. #6
    newtoAccess is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Nov 2009
    Posts
    226
    are you saving to delete all code for that specific control?
    Whe not just create anew one?

  7. #7
    newtoAccess is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Nov 2009
    Posts
    226

    Smile

    Fixed it.

    thanks


  8. #8
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows XP Access 2002
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    How about sharing your solution with others?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 11-10-2009, 03:20 PM
  2. Replies: 2
    Last Post: 09-24-2009, 08:07 AM
  3. Replies: 4
    Last Post: 07-22-2009, 02:33 PM
  4. Open to specific form
    By ecpike in forum Forms
    Replies: 2
    Last Post: 06-12-2009, 08:32 AM
  5. In a field on a Form, on click open another form
    By jackieagra in forum Programming
    Replies: 1
    Last Post: 03-20-2008, 09:44 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums