A2000-2002 incompatibility with Recordset property

[SunWuKung]

Silly me - I thought that if I told Access2002 to save my adp file in an Access2000 form it will be Access2000 compatible.

Access2000 gives the following error message:"Method or data member not found" at the line Me.DropdownControl.Recordset=rst

Its probably because of the different versions of Microsoft Access Object Libraries - version 10 probably knows Recordset as a property and 9 does not.

Do you have some suggestions how can I make my code run on Access2000?

Can use Object Library 10 in Access2000 somehow?
Or do I need to change the code everywhere - and what else is incompatible?

Thanks for the help.
SWK

 

[SunWuKung]

That is what I thought.

I will need to convert all

SQLstring= _
"Select .................."
rst=cn.Execute(SQLstring)
Me.DropdownControl.Recordset=rst

Into

SQLstring= _
"Select .................."
Me.DropdownControl.RowSource=SQLstring

which is not a big deal in most cases but sometimes the SQLstring is the result of a lot of string manipulation and becomes too long to use as a RowSource.

Do you have a suggestion what should I do in these cases?

Thanks
SWK