Hi Exfriend
Thanks for the reply.
I did try it and it works but the problem now I don't know how to update each selected record on my table. If you can show me a sample code on how to do it this will be very helpful for me. Sorry for asking too much as I'm new with access vba...
Thank you again