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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Simple Access subForm question 0
Excel Is it possible to ask a question within a question? 0
Disable/enable or lock/unlock cells in VBA dependent on other cells values 2
Set subform record enable/no enabled 2
Access Cascading combo/query in table/subform 0
Update subform with combobox change on main form 1
Access Select, Copy,Paste and Save data from subform in Access 2007. 0
subfrom visible/ invisible controlled by checkbox 1

Top