Access Form Changing Colors when checkbox selected

[540MahoneyJF]

Good Day,



I have a database where it manages team members files. Within the main form there is a sub form for member info which contains a checkbox (Flag_Member_File). When the checkbox is checked, I want the subform to turn its background color to Red. I have tried researching on here but I haven't had any luck. Can anyone assist with the code for the form to do that?

[Micron]

If the subform is a data sheet I think the answer is, you cannot, so what is it? Then what's supposed to happen if the box is unchecked (no one ever seems to think about that in these requests)?

Use the checkbox AfterUpdate event to set the subform detail colour property. If the control is True (you don't need the Value property) then change the colour.

The subform reference would be

Forms!YourFormName.YourSubformCONTROLname.Form.Detail.Backcolor =

NOTE subformcontrolname is the name of your subform control which not necessarily the name of either form.

To restore the colour if box is unchecked you'd need to know what it was before while testing for both True and False and acting accordingly.

[540MahoneyJF]

Hi the subform is a form with member details laid out in fields for data entry. The checkbox when checked would be used to flag a members file and then turn the background colour red. When the checkbox is unchecked it should return the form back to original colour of white.

[Welshgasman]

I would look at conditional formatting.?
https://www.google.com/search?q=acce...hrome&ie=UTF-8

[Micron]

That doesn't tell me if the subform is a data sheet or not. Could be continuous or single record form. Either would work but each of those would require a different event. Datasheet not possible. So I'd rather not delve into this only to have you tell me it doesn't work and it turns out that is because it's a datasheet view. Or it doesn't work because it's a single record view and the background is red no matter who's record you're looking at. Quite simple to figure out what the form is at your end and let me/us know.

To clarify, you want the background of the whole subform to become red just because one record has a checked box? You could also copy/compact/zip and upload your file here and eliminate some back and forth.

[Micron]

I would look at conditional formatting.?

You can alter form detail section colour with cf?

[540MahoneyJF]

Hi, the form is a single record form. Not a data sheet or continuous form. And yes I want the background of the whole subform to change to red if the checkbox is checked with it going back to normal when it’s unchecked.

[Micron]

Then you will need to use the current event (at least I'm assuming user is navigating from one record to another)

Private Sub Form_Currrent()
If Me.Check6 = True Then
   Me.Child4.Form.Detail.BackColor = vbRed
Else
   Me.Child4.Form.Detail.BackColor = vbWhite
End If

End Sub

Use your own object names for the checkbox and subform control (Check6 and Child4).

[Welshgasman]

You can alter form detail section colour with cf?

No, I was thinking of the controls. Sorry

Could perhaps piggyback off the fore/back color of a control set by CF ?