Hi Thanks for your reply..

I have found a workaround that works for now..

step1: insert values
step2: update recordset
step3: close recordset

step4: open table again by select * query
step5: close without any operations

step6: carry on with crystal reports

steps 4 & 5 make the difference.. It works for now , but i am not sure
of the method that it will work all times..

Thanks again for your reply

Regards
Easwaran.K.V