Allow edit or not in form & sub form

[afshin]

i have a one form with some sub form.
when user don't want to insert any record,i want to form not editable.
but when user want to insert some record,i want to form and sub-forms is editable.
for this,i write:

Private Sub Form_AfterUpdate()


Me.AllowEdits = True
Me.Read.Requery
Me.Read.Visible = True
Me.Read.Enabled = True
Me.Read.Locked = False
End Sub




Private Sub Form_Load()
Me.AllowEdits = False
Me.Read.Enabled = False
Me.Read.Locked = True


End Sub

"Read" is name of sub form.
but when i want to insert some record in form,
sub form don't visible.

[ItsMe]

Your subform resides in a control. You can hide or show the control. The form, itself, is the object that has the Allow Edits property. Your code will need to make a distinction between the two.

Me.Read.Visible = True
Me.Read.Form.AllowEdits = True 'Use .Form to access the form object and its properties/methods

[June7]

Advise giving the subform/subreport container control a name different from the object it holds, like ctrDetails.

[afshin]

i test not only suggestion of ItsMe but also June7,but my sub form is invisible yet.

[ItsMe]

In order to get the correct syntax you will need to identify the name of the control that contains the subform. Do you know the name of the subform control? What did you place inside the control, is it a form object or a table object?

[afshin]

Sub form name is "Read".sub form is showed in right picture,it is contain text box,combo box and other sub form.

[ItsMe]

Did you use the wizard to create your subform? Did you use a table object when the wizard asked you what you wanted to use as your subform?

[afshin]

My sub form is other form object,not table.

[ItsMe]

If the name of the Control is "Read" then you would use the example in post #2. The only other thing I can think of is to include the name within brackets.
Me.[Read].Visible = True

Here is some reference material on referring to subforms within forms
http://access.mvps.org/access/forms/frm0031.htm

[afshin]

i test all of them:
Me.[Read].Visible = True
Me!Read.Form.Visible = True
but sub form1 and sub form2 invisible yet.
but when i open that sub forms in design view,visible property of them are YES.