Have you checked the properties of your recordset (CursorLocation, LockType, CursorType) ?
>That's ok but I still have an error.
>I try doing it localy and it works perfectly.
>When I create the object in the mts it doesn't work!!
>The best behavior I get is with the function; at least it doesn't rise me an error: I can do well the loop but I still can't asociate it to the datacombo
>
>I get this error in the line Set DCmotivo.RowSource = RsGrilla (I'll try to translate it to English):
>error in the method RowSource of the object Datacombo
>thank you
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com