How to automatically save a VALUE into a table field?

[ayinky]

Thanks thanks thanks and big thanks to you !!!

That's interesting, but it's your turn now to convert what I've already posted to match your project. I'm happy to provide the expertise, but I don't see my role as doing the donkey-work for you.

Mr Neopa,

Millions thanks to you for assisting me on solving my prob. With the codes given, I finally managed to complete my On Leave App. I've also done with my presentation to my GMD just now, he's 100% satisfied and ups for admin use.

You saved my day! Thanks to Bytes!!!

[NeoPa]

Pleased to hear it :-)

I guess you worked out [Control5] was entirely redundent in the end (hence it was no part of my suggested solution) ;-)