Results 1 to 5 of 5
  1. #1
    graffiti is offline Newest Newbie ever
    Windows XP Access 2003
    Join Date
    Nov 2011
    Location
    Worthing, south coast of the UK
    Posts
    21

    Unhappy Tabbing to the next control changes the content of two text boxes.

    Good evening Accessors.

    I Only work on this project occasionally and have just seen this odd action. I had noticed it before but not realised what I was seeing.

    I have a small form being used as a dialog box, a log in box. It has a textbox for user name, a textbox for password and an OK button. I also have a small table with a couple of test users details.

    I enter a username. Tab to Passwork, OK.
    I enter a password. Tab to OK button... fail. Note the OK button has not yet been pressed.
    The fail is that I suddenly I get the content of another record from the users table populating the textboxes where a nanosecond ago was the text the user had entered. Why?



    If I use the mouse to click on the OK button the text doesn't change.

    If I try different entries from the table it always goes to an entry further down, including a non existant entry it shows as *deleted*.

    I've searched my code for any references to the "boxInputUserName.Value" and there is only two. One clears the value to ensure nothing is left between sessions and the other reads the value for processing. I have not written any code that writes to these box's.

    So, what code *is* called when the tab button is pressed? I have NO routines written for the tab button. All my code starts once the OK button is pressed, but the change happens before that so I can't even set a breakpoint and follow it!

    Can anyone advise please? I'm (easily) confused. Thanks.

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    My guess is that the form is bound to a table and the Cycle property of the last textbox isn't set appropriately.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    graffiti is offline Newest Newbie ever
    Windows XP Access 2003
    Join Date
    Nov 2011
    Location
    Worthing, south coast of the UK
    Posts
    21
    Quote Originally Posted by pbaldy View Post
    My guess is that the form is bound to a table and the Cycle property of the last textbox isn't set appropriately.
    Good morning P.

    You were spot on. In fact, as a newbie, I didn't know that property existed, but I'll watch out for it from now on. There's a LOT left to learn, but I'll get there. Thank you.

    Mike.

  4. #4
    graffiti is offline Newest Newbie ever
    Windows XP Access 2003
    Join Date
    Nov 2011
    Location
    Worthing, south coast of the UK
    Posts
    21

    Solved.

    Tried to change the title but even in advanced edit it won't show. I seem to remember there being a time limit, but I've only been absent for the weekend.

  5. #5
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    Happy to help Mike. You can mark a thread solved in Thread Tools. I've gone ahead and done it.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Replies: 9
    Last Post: 06-04-2014, 10:45 AM
  2. Replies: 15
    Last Post: 04-01-2011, 11:41 AM
  3. Replies: 0
    Last Post: 02-27-2011, 07:03 AM
  4. Replies: 1
    Last Post: 02-16-2011, 11:40 AM
  5. Replies: 15
    Last Post: 09-18-2010, 01:19 PM

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