Thanks very much for the assistance it made my life easier.

another thing i want to ask....is there a way to highligt a particuler row when the mouse is moved...

Hi,

Thanks...

It really made my life easier.............

Thank you so much Richard,

I really appreciate your assistance.

thanks once again.....its working really fine.

Regards

here is my script::::

SELECT

SubsTrans

.PubCode,

SubsTrans

.[Update],

CASE

SubsTrans.Trans_id