FORM function no longer work after upgrade from 97 to 2003

[NickName]

We have a form-based application running all right. But once upgraded
from 97 to 2003. One of the functions no longer work, for instance,
one function that queries all sellers and populates them, upon a
selection (of a seller), the next box populates all the products from
this seller, now, the second box fails to do the on-demand population.
I'm not an Access form's programmer myself. What could be wrong and
how to fix it?

TIA.

[pietlinden]

The first thing I would check for is the DAO library not being
registered. Open a code module (or code behind a form) and go to
Tools, References and make sure there are no libraries marked "MISSING"
and that DAO is registered. If you're going to use ADO and DAO
together, make sure you prefix all objects that are in both libraries
(recordset is the big one) as DAO.Recordset or ADODB.Recordset.

But my bet is that it's the DAO stuff not compiling. See if your code
compiles and if it doesn't the offending line should be highlighted.

[NickName]

Thanks for the pointers. I just open up a code module in Access 2003,
5 References are checked:
VB for Applications
MS Acess 11.0 object library
OLE Automation
MS DAO 3.6 Object Library
MS Active Data Objects 2.1 Library

' there are no libraries marked "MISSING", what do you mean exactly by
that?

'DAO is registered', regedit --> then local_machine, software? then ??

'See if your code compiles', well, this is not my code, nor am I a VB
or Access FORMs programmer, alternative?

TIA.

[NickName]

Any other possible option(s) to solve this problem?