References 2002 vs 2003

[Steven R via AccessMonster.com]

I have v2003 at home, and v2002 at work - the following code block works with
my '02 but blows up on my '03 - what reference do I need to check ?

<<Private Sub cmdPrev_Click()
On Error GoTo cmdPrev_Click_Err
DoCmd.GoToRecord , "", acPrevious
cmdPrev_Click_Exit:
Exit Sub
cmdPrev_Click_Err:
MsgBox Error$
Resume cmdPrev_Click_Exit
End Sub>>

It blows up on << MsgBox Error$ >>

 

[TC]

Access VBA can display about 50 squintillion different error messages.

"Blows up" is not one of them, if I remember correctly.

TC

 

[Guest]

Any reference failure can cause any error message.

You need to check all of the references.

(david)

 

[TC]

Depends on what message he's getting. It might (for example) be: "Can
not go to previous record"

But as he has disappeared, we shall sadly never know.

TC