Master/Detail Through ADO

[Rohan_Powle]

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)

[Dim]

I'm not a big db person, but how about a DoEvents b4 refreshing? It might settle things down.

Gl,
D!m

[Clunietp]

Have you applied the latest VB Service pack? (currently 4)