Request a little assistance. I’ve created a field within a form in MS Access that allows me to disable Check boxes when selecting various values within the same field. For example, within the [Shop] field there are three values; “ShopA”,” ShopB”, and” ShopC”. When selecting either of the fields it auto disables the checkbox128, and checkbox 130 and so on…. respectively. (Works great!). However, I would like to also have “ShopC” within that same field, disable additional boxes that don’t necessarily apply to “ShopA” or “ShopB”. If you need additional information please let me know. Thank you for addressing this issue.
Code as follows..
Sub Form_Current()
If (Me![Shop].Value = "ShopA") Or (Me![Shop].Value = "ShopB") Or (Me![Shop].Value = "ShopC")
Me!Check128.Enabled = False
Me!Check130.Enabled = False
Else
Me!Check128.Enabled = True
Me!Check130.Enabled = True
End If
End Sub
Private Sub Shop_AfterUpdate()
If (Me![Shop].Value = "ShopA") Or (Me![Shop].Value = "ShopB") Or (Me![Shop].Value = "ShopC")
Me!Check128.Enabled = False
Me!Check130.Enabled = False
Else
Me!Check128.Enabled = True
Me!Check130.Enabled = True
End If
End Sub
