I am trying to set a checkbox on my subform to allowedits=true by using a button on my main form. I've tried this but it does not work:
Forms!reviewBilling!reviewBillingSub.Form.Controls .cbxAudited.AllowEdits = True
I am trying to set a checkbox on my subform to allowedits=true by using a button on my main form. I've tried this but it does not work:
Forms!reviewBilling!reviewBillingSub.Form.Controls .cbxAudited.AllowEdits = True
AllowEdits is a property of form. Remove reference to the combobox. Then no controls on the form will be editable.
Really should use textbox and combobox Conditional Formatting if you want to just disable the one control.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
If you just want to control a single Control, in the OnCurrent event of the Form the Subform is based on, set the Locked property of the Checkbox to True:
Code:Private Sub Form_Current() Me.cbxAudited.Locked = True End Sub
Then set it to False with your Command Button
Linq ;0)>