Help needed to finish project 99% done.

[actionkat]

HI all
I have taken years to make a database that is 99% finished but I am having problems with the database finding combo.
I get an error when I try to run parts of the database.

---------------------------
Microsoft Visual Basic
---------------------------
Compile error:

User-defined type not defined
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Code line

Private Sub FindCombo_AfterUpdate()

( CTable As Recordset )

I am gettin a bit frustrated finding where i have gone wrong, if anyone can tell what i am doing wrong i would be very greatful..
many thanks
P.S forgot to say I originally setup the project in access 98 now it is in 2002 I’m not sure if I screwed something up when this happened

 

[pbaldy]

Typically when upgrading you have to disambiguate your references. First make sure the DAO reference is checked in Tools/References, then change

Dim whatever as Recordset

to

Dim whatever as DAO.Recordset

 

[boblarson]

And to give a bit more of info to follow Paul's post -

Access 2002 has ADO as the default in the references. So, in order to use DAO you would need to set a reference to DAO, if one isn't already set.

 

[actionkat]

Cheers guys i have give that a try worked great, that's sorted now.
thanks again A1 help saved me pulling my hair out any more, much apricated