Need advise on which event to use.

[Pack10]

I have 3 check boxes with 3 text boxes -- when the user clicks the checkbox, today's date gets stored to the text box.
(They are answering questions?)
When the user has selected all three checkboxes, I want to gray out the text box and checkbox. Kind of "lock it down".
But I get "You can't disable a control while it has focus" when I am on the last checkbox (which does make sense) . Where else can i place this code.?

thx

 

[vbajock]

I'd do it on the click event of each check box since the user could possibly finish on any given check box. You would need to put something along the line of:


Sub SomeCheckBox1_Click()

If (SomeCheckBox1=True and SomeCheckBox2=True and and SomeCheckBox3=True) then

'move the focus off of the controls I want to play with
me!SomeOtherControlLikeAnExitButton.setfocus



'code to disable whatever
SomeCheckBox1.enable=false
'etc


Endif


End sub

in the Click event

 

[Pack10]

thanks, I'll give it a go.

 

[Pack10]

Beautiful, it worked like a charm.