>
>>Set rstTempChild = rstCategory.Fields("Item").Value
>
>actually i have done that code before bringing the issue on UT, unfortunately that wouldn't work. Hierarchical recordsets doesn't support adding/editing of records.
>If you want to try it yourself:
>rsTempChild.Supports(adAddNew) --> returns FALSE
How do you open the recordset?
See that article:
http://support.microsoft.com/support/kb/articles/Q196/0/29.ASP
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com