Automate checkbox using VB

[cinderella]

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]

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]

Ur absolutely correct.

Hi ecawilkinson,

Your absolutely right.

Sorry to waste your time, i misinterpreted your thread.

Thanks for your help !!!!!