+ Reply to Thread
Results 1 to 4 of 4

Error 2110 - can't move focus

  1. #1
    Registered User
    Join Date
    08-27-2014
    Location
    Albany, NY
    MS-Off Ver
    Office 2010
    Posts
    91

    Error 2110 - can't move focus

    I cannot for the life of me figure out why this error pops up for one user and not others. Basic gist: I have a user-form that the user fills out, and clicks update. Upon clicking update the form asks "Would you like to update another record?". If the user answers vbYes the line of code is currProvNum.SetFocus to start over. However this error pops up consistently for random users. here is the code around the error, The file is quite big so if it needed I will post it, but for now just the code:

    Please Login or Register  to view this content.

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,646

    Re: Error 2110 - can't move focus

    Is the control you are trying to set focus on in a frame or on a page of a multipage?

    Is it enabled?
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    08-27-2014
    Location
    Albany, NY
    MS-Off Ver
    Office 2010
    Posts
    91

    Re: Error 2110 - can't move focus

    As an aside, I did check the properties of the combobox and it shows as enabled. Could it be because the msgbox is active and the userform is not? Would currProvNum.SetFocus be trying to set the focus of a non-existant currProvNum on the MsgBox?

  4. #4
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,646

    Re: Error 2110 - can't move focus

    The message box isn't active when you try to set focus to the control, focus should have returned to the userform as soon as the user clicked Yes/No on the message box.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Runtime error 2110 - SetFocus on label not working
    By mc84excel in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-04-2014, 08:43 PM
  2. Scrolling in a textbox can move focus outside it?
    By madhg in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-07-2009, 12:57 PM
  3. Cant move focus to the control because (Error)
    By realniceguy5000 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-28-2009, 09:40 AM
  4. Move cell focus in VBA
    By VD in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-02-2006, 11:20 AM
  5. [SOLVED] setfocus sometimes gets error 2110
    By tmort in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-18-2005, 11:05 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1