I am writting this code which dont seem to be wrong then too a error msg is flashed....I am writting this code to change the child record source depending upon the masters PK.

the code is
----------------
orditem.ADSH.CommandType = adCmdUnknown
orditem.ADSH.RecordSource = "select * from ordlotsch where ORDPSNO=" & psno
orditem.ADSH.Refresh
-----------------
for few time it is working properly but then a error is flashed saying Referesh Method of ADODC Failed.....
after this VB is terminating itself..

Please help me to solve this problem
and if u can give me the different Master Detail forms Codes..it will be helpful for me to use in my next projects..

Thankzz in Advance..
___________________
Rohan(Mumbai,India)