Access 2002 ListIndex Error 7777

[jabrony76]

HI all,
Have a mde that works fine in Access 2000 but one user now has Access 2002 and a commandbutton is throwing the run-time error '7777' you've used the ListIndex property incorrectly. When I debug here is the code that it doesn't like:

Private Sub Command36_Click()
Combo27.SetFocus
Controls("combo27&quot.ListIndex = Combo27.ListIndex + 1
End Sub


The code is meant to bump up a subform one record (there's a -1 that bumps down that is erroring too).

Thanks,
Andy

 

[tbkeith3556]

Having the same problem with access 2002. It appears to be that the combobox has to have the focus during the listindex call, but i haven't been able to figure it out either. Let me know if you have any luck.

 

[Draknor39]

Read this thread for your answer

thread181-27567