View Full Version : Automate checkbox using VB


cinderella
05-28-2008, 04:54 AM
Hi Everyone,

Hopefully someone would be able to help.

My problem is, is that: How can a "checkbox" be automatically filled in ie: ticked "YES" when a user presses a button.

I would like to know whether or not there is a possible VB solution?

At the moment, i am using macros, however, i do not want the "Checkbox" to be seen - and if a hide it, it does not tick "YES".

Help would be greatly appreciated.

ecawilkinson
05-28-2008, 05:09 AM
in the onClick procedure for the button, put:

chkYourCheckBox.value = true

obviously, subsititute chkYourCheckBox with the actual checkbox name in your db.

HTH,
Chris

cinderella
05-29-2008, 02:13 AM
Hi ecawilkinson,

Your absolutely right.

Sorry to waste your time, i misinterpreted your thread.

Thanks for your help !!!!!