Solved Troubleshooting Subform (1 Viewer)

[jamesave]

Not sure if this is supposed to go to the VBA forum or this.. but here it goes:

I have a form with a linked subform.
The subform is populating the proper view of the data (filtered on the parent linked field)

Then I add a button on the main form to allow adding a new record for the subform:

Private Sub cmdAddNewRecord_Click()
Me!Sfr_PcsSetBOM.Form.AllowAdditions = True
Me!Sfr_PcsSetBOM.Form.AllowEdits = True
Me!Sfr_PcsSetBOM.SetFocus
DoCmd.GoToRecord , , acNewRec
End Sub

But still it doesn't allow for edit in the record, even after the subform is displaying a new record line

I've checked the main form and subform allowadditions and allowedits.
Also check by going to the subform as it's own window with datasheet view. Manually, I can add the record.
All checked, I still can't add edit the newrecord in the subform from the main form. How should I troubleshoot this problem?

 

[theDBguy]

Does the main form also go to a new record or just the subform?

 

[jamesave]

just the subform

 

[theDBguy]

just the subform

If not too troublesome, you might consider posting a sample db to demonstrate the problem.

 

[jamesave]

here you go. Take a while to clear up unneccesary parts/data

 

[theDBguy]

I tried to see what's going on with your forms, but it's taking too long, so I decided to test it with a new form, which seems to work. My guess is maybe your form got corrupted. Just my 2 cents...

 

[xavier.batlle]

You have to unlock the subform on the Private Sub cmdAddNewRecord_Click() event

    Me.sfr_PcsSetBOM.Locked = False

 

[jamesave]

this is embarassing. Can I delete this thread? Thanks Xavier.Battle

 

[jamesave]

thank you for your time too @theDBguy

 

[Gasman]

this is embarassing. Can I delete this thread? Thanks Xavier.Battle

Even if you could, better to leave it, in case someone else make the same error?

 

[jamesave]

Even if you could, better to leave it, in case someone else make the same error?

Lesson Learned. somehow I missed that it was locked in the VBA when the form is opened.