Just Looking for Clarification...

[faythe1215]

I have a form "frmRecipes" that contains subform "frmIngredients". Both are set so as to not allow any additions or edits.



I am creating a button called "Add" on frmRecipes which will need to add records to the tables associated with both forms.

I understand that the following code will allow me to add a new record on the main form:

Private Sub btnAdd_Click()
    Me.AllowAdditions = True
    DoCmd.GoToRecord , , acNewRec
    Me.txtRecipeName = " "
    Me.AllowAdditions = false
End Sub

If I were to modify the code so as to do this, would that Me.AllowAdditions refer to frmRecipes or my frmIngredients?

Private Sub btnAdd_Click()
    Me.AllowAdditions = True
    DoCmd.GoToRecord , , acNewRec
    Me.txtRecipeName = " "
    Me.AllowAdditions = False
  
    DoCmd.OpenForm "frmIngrendients"
    Me.AllowAdditions = True                  '  <------- THIS ONE <-----------
End Sub

[June7]

The button is on the main form? The Me. reference is for the main form. The Me alias always refers to the form or report the code is behind regardless of where focus is.

Since frmIngredients is a subform on frmRecipes, why do you want to open another instance of the form?

[faythe1215]

I only set to open it because I thought changing the focus might allow me to change the "Me." reference.

Is there a way to add a record for my subform from my main form?

[June7]

Options:

1. change form properties as you are currently trying - addressing a subform to do this is tricky

2. maybe opening the second instance of subform will allow directly referencing the form - I've never tried multiple instances of a form
Forms!frmIngredients.AllowAdditions = True

3. programmatically add records to the underlying tables and then requery the form/subform

[faythe1215]

Hmm... all right, I'll mull this over a bit.

Thanks for the help!

[Missinglinq]

I have a form "frmRecipes" that contains subform "frmIngredients". Both are set so as to not allow any additions or edits...

You need to understand that the Subform is actually a Subform Control, and as such, regardless of how AllowAdditions is set for the Form the Subform is based on, you will not be able to add Records as long as the Main Form is not editable! The Access Gnomes consider anything you try to do to the Subform as 'editing' it.

Linq ;0)>