Unable to Edit in SubForm

[faythe1215]

I am currently attempting to fix my "frmRecipes" with subform "frmIngredients". I have been working on the "Add" button.



Functionally speaking, I should be able to click the "Add" button and basically populate a blank field. I am able to edit everything on the main form, but not on the subform. I checked the subform's properties and the only thing I have not allowed are deletions.

I have attached a copy of the database for review. Thanks in advance!

Attachment 19598

[June7]

The code works. New record added in both tables. Don't know yet why can't edit subform. The subform isn't even showing records. I've never tried anything like this with subform.

I have narrowed it down to the AllowEdits property on the main form. When this is set to No, the subform records do not show and the subform is not editable. Even though code modifies this property, it still doesn't seem to set the subform as editable.

[Missinglinq]

When a Form's AllowEdits Property is set to No, you cannot edit Controls on that Form. What we typically call a Subform is, in reality, a Subform Control, and hence it cannot be edited, when the above is true. How the AllowEdits Property is set on the Form that resides in the Subform Control doesn't really matter.

The usual workaround is to set the Main Form's AllowEdits Property to Yes, but to Lock all of its Controls on the Main Form except the Subform Control.

Linq ;0)>

[faythe1215]

My code actually sets AllowEdits to True, which, as far as I know, is why I'm able to edit the Recipe Name and other objects in the main form.

Since I have it set to True and am able to edit things in the main form, shouldn't I also be able to edit the subform?

[Missinglinq]

If I'm looking at this correctly, you're only setting AllowEdits = True after you click the button to add a New Record, which is kind of confusing, as why would you have a need to Edit a new Record?

If you're asking why, after clicking this button that sets AllowEdits = True, you cannot then move to another Record, on the Main Form, and then Edit something on the Subform, the answer is that when

1. AllowEdits is set to No in the Properties Pane
2. VBA Code is used to set AllowEdits = True
3. You move to another Record

the AllowEdits Property, after you perform Step #3, above, reverts to its setting as done in the Property Pane, not to how it was last set in code.

Linq ;0)>

[faythe1215]

AllowAddition was set to True so that I could add the new record.
AllowEdits was set to True so that after the record was added I would actually be able to input the information as needed.

I thought that setting it to true would change the form's setting - THE ENTIRE FORM - until I changed it back.

Knowing that it works that way, I'll have to find another way to make this work... Thanks!

[faythe1215]

I'm sure this is a clumsy fix, but it worked:

Private Sub btnAdd_Click()
    Me.AllowAdditions = True
    DoCmd.GoToRecord , , acNewRec
    Me.RecipeName = " "
    Me.AllowAdditions = False
        
    Dim RecNum As Integer
    RecNum = Me.CurrentRecord

    DoCmd.OpenForm "frmIngredients"
    DoCmd.GoToRecord , , acNewRec
        ' Link to tbl1Recipe
    Forms!frmIngredients!txtRecipeID = RecNum
        ' Set to Dummy Value
    Forms!frmIngredients!cmbIngredientName = 100
    DoCmd.Close
    
    Me.Refresh
    Forms!frmRecipes.SetFocus
    Forms!frmRecipes.AllowEdits = True
End Sub