Solved Sub datasheet not allowing new records after setting no edit in main datasheet form (1 Viewer)

[Jomat]

Have anyone ran into this issue?
I have a form with a subform. Both are viewed in datasheet view. When I set the main datasheet form to no edit, the subfrom (viewed in datasheet view) no longer offers a new record input line. Any ideas? Thanks.

 

[LarryE]

That's because a subform is just another control type of the main form so if you set the mainform to not allowing edits, naturally as a control type, the subform won't allow editing or adding new records either.

 

[Jomat]

The main form still allows new records. Just the sub form does not.

 

[isladogs]

Not sure how you have a datasheet subform showing in a datasheet form
Care to explain with screenshots in design view & form view

 

[CJ_London]

Suspect op means subdatasheet

 

[Jomat]

I'm not at the computer now but what I did was: main form datasheet view, subform dropped onto main form. I didn't space anything. Sub form also set to display in datasheet view. Link the ids then open the main form. It looks. Like the the table with the sub table expanded.
I found a way to make it work. Since I don't want end users to edit the main form data and only add to the sub form. So I coded the main form that if the id is blank then certain fields can be edited or added. I use the on current event and set the codes to use the me.myfield.locked =true
Sorry I will add an example later when I get back to the desk. My apologies if I am not clear on the explanation above.

 

[Jomat]

I've included a sample db. You can see what I did. The main form will be the example. Ignore all the other junk reports and etc.
Any feed back? Let me know. I did forget to lock one of the field though. Thanks for all the responses.

 

[CJ_London]

When I set the main datasheet form to no edit, the subfrom (viewed in datasheet view) no longer offers a new record input line.

works for me - you have to complete the entire line. If you don't you can't go back to edit

 

[Gasman]

works for me - you have to complete the entire line. If you don't you can't go back to edit
View attachment 107302

Edit was set to Yes in the mainform though?

 

[Jomat]

Gasman, yes edit must be set to yes. That was the original issue. If I set edit to no on the main form, then the subform won't allow new entries. I found this odd so I had to come up with another way.

 

[CJ_London]

Edit was set to Yes in the mainform though?

tried both yes and no didn't make any difference to the subform - you can still add new records. See below, you can see I am in the main form from the highlighted text

perhaps I'm not understanding the issue

 

[Gasman]

Hmm,
If I open as is, I get first pic
If I go into design and then back out, I get the second pic.?
So I expanded the control to be able to see the subform, and when I changed main form to AllowEdits = No, then I could not add the subform record, before that I could.

O/P, try locking your mainform controls, except for the subform control, if you get the same as myself?

 

[Jomat]

This was the original problem. If I locked the main form, (set it to no edit) then the subform does not allow new entries. I've included a sample below. I get the same results as Gasman.

 

[Josef P.]

You can use code to set AllowAdditions/AllowEdits to true/false.

In design mode: set AllowEdits to True

Code in main form:

Private Sub Form_Load()
   Me.AllowEdits = False
   Me.FRM_MESSAGES_RESPONSE_SENDER_MASTER_RESTRICTED.Form.AllowEdits = False
End Sub

/edit:
Note: AllowAddition = True in (Form_Load) will only work for subform in 1. record.

 

[Gasman]

You can use code to set AllowAdditions to true.

Code in main form:

Private Sub Form_Load()
   Me.FRM_MESSAGES_RESPONSE_SENDER_MASTER_RESTRICTED.Form.AllowAdditions = True
End Sub

Could you not just use Me.Parent?

 

[Jomat]

You can use code to set AllowAdditions to true.

Code in main form:

Private Sub Form_Load()
   Me.FRM_MESSAGES_RESPONSE_SENDER_MASTER_RESTRICTED.Form.AllowAdditions = True
End Sub

It is weird. I've tried that already. When I try to force it, only the first record in the sub form allows new entry and any thing else in the sub form does not allow new entries.

 

[Josef P.]

See attachment:

 

[Gasman]

You can use code to set AllowAdditions/AllowEdits to true/false.

In design mode: set AllowEdits to True

Code in main form:

Private Sub Form_Load()
   Me.AllowEdits = False
   Me.FRM_MESSAGES_RESPONSE_SENDER_MASTER_RESTRICTED.Form.AllowEdits = False
End Sub

/edit:
Note: AllowAddition = True in (Form_Load) will only work for subform in 1. record.

I am struggling to see the point of setting edits to no in design mode, only to unset them in form load?
Edit: ok, it seems that would allow just one record?

 

[Gasman]

It is weird. I've tried that already. When I try to force it, only the first record in the sub form allows new entry and any thing else in the sub form does not allow new entries.

That was mentioned in an edit of that post?

 

[Josef P.]

@Gasman: Posts (my change and the new post) overlapped in time, so I still added the note in #14.
First I tested:

Private Sub Form_Load()
   Me.FRM_MESSAGES_RESPONSE_SENDER_MASTER_RESTRICTED.Form.AllowAdditions = True
End Sub

this has only effect for 1. record.