Conditional Formatting in Multiple Record subform

[Lkwdmntr]

Hello,
I have a subform that has two sets of Yes No checkboxes. The second set of checkboxes doesn't need to be used unless there is a tab reference in the record.

My wish is to have the boxes set that you can only check yes or no, not both.

The other wish is to have the checkboxes disappear if there is no tab reference.

I was able to get it to work on one record and all the records after that reflected the change. Here is a Zipped copy of my database. Please don't worry about the design (I already know it is flawed).

The Sub_MonSTChallenges - Sub_SunSTChallenges are the forms I am using. They are part of the FRM_Mon_Challenges - FRM_Sun_Challenges forms.

Most of the Forms are Pop out and Model. I stopped the opening form from going full screen, but not the others. In order to get Temp Values set for testing. There are a few steps to take. "Enter", "Reporting Forms", Select User Holly Flowers(she has the most data for testing.), "Next" and then right-click and go into design view and you're ready to test anything.

 

[Deleted member 147267]

My wish is to have the boxes set that you can only check yes or no, not both.

Put them in an option frame (that is a specific control) and only one can be chosen. They need to be added properly (the frame will go black as you draw the check in place). Can also use option buttons. The value of the button is passed to the frame, so you validate/bind the frame, not the buttons.


Don't know what a tab reference is. A tab control? A tab control page? A navigation form tab?

Forgot the file?

 

[theDBguy]

Hi. Since Conditional Formatting doesn't work with Checkboxes or Buttons, I tend to use Textboxes to simulate them and then use code to perform the action the original controls were supposed to do.

 

[isladogs]

See if this thread helps https://www.access-programmers.co.uk/forums/showthread.php?t=305659

 

[Deleted member 147267]

How did this morph into conditional formatting of checkboxes? The requirement was to be checked or not visible. Anyway, time to wait for a response IMHO.

 

[Lkwdmntr]

Sorry, I did forget the file. I working on something else that is blowing my mind. I might make a post on it in another thread. Heres the file that I believe you zipped to make it small enough to upload. I still would like to know how you did that.

 

[Galaxiom]

How did this morph into conditional formatting of checkboxes? The requirement was to be checked or not visible. .

Because it is not possible to make checkboxes conditionally visible on a continuous form. It is possible to use conditional formatting to disable them.

 

[theDBguy]

How did this morph into conditional formatting of checkboxes? The requirement was to be checked or not visible. Anyway, time to wait for a response IMHO.

Hi Micron. Check out the image I posted on this previous thread and please imagine the buttons with the up and down arrows are checkboxes. Notice how in some rows the buttons are not visible? This is what you can do with Conditional Formatting. I was just saying you can apply this technique on checkboxes too, which Colin actually demonstrated just a few posts after mine in that other thread. Hope that makes sense...

 

[Deleted member 147267]

Because it is not possible to make checkboxes conditionally visible on a continuous form. It is possible to use conditional formatting to disable them.

I guess that "continuous form" info is in the post title, because it sure ain't in the post itself. I'll bow out...

 

[Lkwdmntr]

I'd be very happy just disabling no box If the yes box was checked or vice versa.

 

[Lkwdmntr]

You see I am using a Yes checkbox and a No checkbox because The client gets accountability points even if they didn't complete there challenge. So, I need both boxes.

 

[Galaxiom]

You see I am using a Yes checkbox and a No checkbox because The client gets accountability points even if they didn't complete there challenge. So, I need both boxes.

Use an Option Group.

 

[isladogs]

Agree with suggestion to use an option group.
However, if you really want to persevere with this, see if my example in this post can help https://www.access-programmers.co.uk/forums/showpost.php?p=1648861&postcount=14
Thanks to DBG for reminding me of the link

 

[Deleted member 147267]

I still would like to know how you did that.

You left images in a table. I forget which one. You should link to images, not store them in Access tables. RE: the suggestion to use option group- see post 2. It makes the most sense., even if you had more choices. That is, of course, as long as this isn't on a continuous or datasheet form, which I still see no definitive answer about.