Chapter 3, Page 70 Access 2000 VBA. I get an error when I
try to click any of the new buttons, and am shown the code:-
(Error$ is highlighted)

This also happens on the version of the Chapter 3 database
supplied on the CD


cmdNext_Click_Err:
    MsgBox Error$
    Resume cmdNext_Click_Exit

It seems to work OK by the time I check Example Database
from Chapter 9 but I cannot see what is different

this is the same problem that Michael Gavel and I have posted under his topic Compile Error:

in my case it is resolved by the time I use IceCream4.mdb, that is at the end of Chapter 4

weird - peter j

You might want to check if you have the statement Option Explicit at the top of your module. This statement will prevent variables being declared "on the fly". Try deleting all of the error processing and see if the error goes away.

I have exactly the same problem. I'm not certain whether it has something to do with an addin or what. It is resolved by Chapter 4, but I would love to know what is causing the problem.

Regards,

Richard Hein