Lock/Unlock check boxes

[Brianwarnock]

Bob beat me to it, check my post.

Brian

 

[boblarson]

Bob beat me to it, check my post.

Brian

So that would actually mean that YOU beat me to it Brian. It just wasn't noticed.

 

[MsMickey0219]

I tried just visible and that did not work either.
Any ideas.

Also, I think I may have left out an important piece of information. I have page tabs on the form. the MCC_Number is on the first page and the check boxes are on other pages. Would this make a difference?

Lisa

 

[Brianwarnock]

The code you have shown in the word doc contains names and codes that look nothing like which we were discussing before.

My sample code was based on the names and codes originally mentioned in the thread.

Brian

 

[boblarson]

I tried just visible and that did not work either.

When you say "did not work" what exactly does that mean. Please be specific. Did you get another error message or did it not display, what?

 

[boblarson]

Also, I think I may have left out an important piece of information. I have page tabs on the form. the MCC_Number is on the first page and the check boxes are on other pages. Would this make a difference?

No, tab controls are treated as if they aren't there.

 

[MsMickey0219]

I thought I had the MCC_Number on the form but I actually have the MCC name as stated in the word doc. I tried changing the name field to "MCC_Name" as well in the syntax.
Should the syntax go in the Form "OnCurrent"?

When I open the form after adding the syntax I go to the tab where the Cardiology check box should not be visible based on my syntax; of course unless that is not what my syntax is saying????? I feel Clueless .

 

[CEH]

First your checkboxes DO need to be set to visible NO, the onCurrent event determines if they are or not. Take a look at this quick VERY simple form. Scroll thru the records. Even, odd numbers 1 to 4....error on any other numbers. Then take a look at the code. I think it may explain itself.

 

[Brianwarnock]

Firstly you should have the visibility of your checkboxes and labes set to yes and then you can ignore the labels as their visibility comes and goes with the checkbox. Try it on Curtis's example.
Note also that he appears to have errors on the odd items in his even CASe as he does not address the odditem label, not a problem if you follow the advice in the first paragraph.

His code is a very useful example of the Select CASE showing the Case Else.

Brian

BTW if you use simple control names with no spaces then ACCESS intellisense will allow you to avoid typos

If you continue to have problems then Compact your DB and attach, zip if necessary

 

[CEH]

OK.....typo...put it together rather quickly....