Error 2105

[vellakaran]

here is the code that is causing the problem:

strVisible = strSubList
frm(strVisible).Form.Visible = True
frm(strVisible).SetFocus
frm(strVisible).Form(strLinkField).Visible = True
If strLinkId > 0 Then
frm(strVisible).Form(strLinkField).SetFocus (bombing here)
End If
frm(strSubDetail).Form.Visible = False

I converted this app from Access 97 to Access 2002. It works fine in 97 but bombs in 2002. It is a frontend Access db linked to mySQL backend. Running Windows XP Professional.

The code above is basically toggling views between a main form and subform. I checked table and the record it is trying to access is there. It also doesnt happen everytime, usually happens the second time i access the subform and make a change and then try and close the subform. (this is when the above code is executed)

Any ideas?

Thanks,
VK

 

[Rolliee]

It sounds like you are in a non-defined record - beyond the present records.


rollie@bwsys.net

 

[missinglinq]

The other thing to consider is that converting from AccessX to AccessXX usually works, but Converting from AccessX to AccessXXX may present problems. Despite what Billy Bob Gate's Boys may say, sometimes you have to go from AccessX to AccessXX to AccesXXX.

Just a point to ponder.

The Missinglinq

"It's got to be the going,
not the getting there that's good!"
-Harry Chapin