Access Enable/Disable Access Subform

J

JBren

Joined
Oct 10, 2012
Messages
16
Reaction score
0
Running Access 2007, Windows 7, trying to build a database. I want to add and option group with two options (Yes and No). If "Yes" is checked, I want the subform to be unlocked and enabled. If "No" is selected, I want it to be disabled and locked. I know it would be an if function but I can't seem to get the options related to the subform.

Am I anywhere close?

Code: 
If Me.grpStatus= "Yes" Then
Me.sfrmFamily.AllowEdits = True
Me.sfrmFamily.Enabled = True
Else
Me.sfrmFamily.AllowEdits = False
Me.sfrmFamily.Enabled = False
 End If
 
Back
Top