I'm having trouble allowing editing on a specific column on a subform. I want to allow the user access to a specific field after clicking a button. I've tried
various forms to enable the field such as
Me.subform.form.fieldx.Enabled = True
Form.formname.subform.form.fieldx.Enabled = True
I've tried all manner of things including replacing . with !
I've then tried allowing edits for the whole subform with
Me.Subform.Form.AllowEdits = True
I've tried putting the button on the sub form to no avail.
This form actually has 2 subforms and in the open event on the main form Me.secondSubform.Form.AllowEdits = True works
I can't think of what else to do
various forms to enable the field such as
Me.subform.form.fieldx.Enabled = True
Form.formname.subform.form.fieldx.Enabled = True
I've tried all manner of things including replacing . with !
I've then tried allowing edits for the whole subform with
Me.Subform.Form.AllowEdits = True
I've tried putting the button on the sub form to no avail.
This form actually has 2 subforms and in the open event on the main form Me.secondSubform.Form.AllowEdits = True works
I can't think of what else to do