Unable to requery a child command in DE

[rekcus]

Problem : Unable to requery a child command in DE

I have this for my parent command :

If DataEnvironment1.rsCommandMain.State <> adStateClosed _
Then DataEnvironment1.rsCommandMain.Close
DataEnvironment1.rsCommandMain.Open sqlStr
DataEnvironment1.rsCommandMain.Requery
RepTermReport.Show

where 'rsCommandMain' is the parent command 'sqlStr' is my SQL string.

I also have a childcommand in the DE under the parent command rsCommandMain. The problem is that there is no way to requery this child command!

Also tried doing stored procedures in the mdb file but to no avail.

Has anybody out there managed to requery the child command?

Thanks,

_______________
VB6/Access 2000
---------------