Access Error 2950! Help!

[qwerty1]

I am tearing my hair out over this. Searched everywhere and cannot find a solution.



I have an access .accb file with one form.
On the sub:
Public Sub Form_Load()
combobox1.SetFocus
End Sub

When the form loads, it sets focus to combobox1. EASY RIGHT?!?!?!?!?!?

It works perfectly fine using Access 2007 on Windows XP.

When I open it on Access 2010 on Windows 7, I get Run-Time Error '2950'!!!!!!!!!
Tried 4 different computers all with the same error!

I cannot figure out how to solve this.
I added the file location and all subfolders to trusted location....IT STILL COMES UP WITH THE SAME ERROR.

[pbaldy]

What is the text of the error? Why not just make that combo first in the tab order? That will make it first to get focus.

[qwerty1]

What is the text of the error? Why not just make that combo first in the tab order? That will make it first to get focus.

Hi, it is a split form.
It I set Tab Stop to Yes, and Tab index to 0, it still does not set the listbox to focus.

[GeekInOhio]

Sometimes you get misleading errors related to missing references, especially when opening a project from one generation of Access in another one.

Try opening up the VBA editor and selecting Tools >> References. Do you have any marked as MISSING? If so, remove them and if necessary replace them. If none are missing, try adding a reference and then closing and reopening Access. Then go back in and remove it again. Sometimes that fixes miss-linked references.