Hi Naomi,

I took your approach and I am able to get all my data. Thanks.

Now, I have m.lnQty that I normally get from the textbox for this to calculate the NetQty in my Select statement. How can I replace that with crsCNT.CurQty and put it back to my Select statement?

Please help.

Thanks,
Sam