automatically insert foreign key in subform

[Neruda]

Hi, I am adding records in a subform using recordsetclone. The subform has Data Entry property set to no and Add Record set to no. The main form PK is linked to the child form fk.
At the moment I am having to add the fk manually to the recordsetclone but I was wondering if that is the default behaviour? Why isn't the fk added automatically by Access? I suppose it is because the record is not written directly on the form but I just wanted to check if I am correct or I am talking nonsense. Thanks

Private Sub addPayment(button As Integer)
 
    On Error GoTo ErrorHandler
 
    Dim rst As DAO.Recordset
 
    Set rstClone = Me.PayChild.Form.RecordsetClone
    Set rst = Me.PayChild.Form.Recordset
 
    With rstClone
        .AddNew
            !fkPaymentTypeID = button
            !fkInvoiceID = Me!InvoiceID
        .Update
        rst.Bookmark = .LastModified
    End With
 
    With Me.PayChild
        .SetFocus
        .Form!txtPaymentAmount.SetFocus
         Debug.Print Me.Dirty
        .Form.Dirty = True
    End With
 
ExitSub:
    Set rst = Nothing
    Set rstClone = Nothing
    Exit Sub
ErrorHandler:
    MsgBox "Error No: " & Err.Number & vbNewLine _
         & "Error Details: " & Err.Description & vbNewLine _
         & "Error in Sub: frmPay\addPayment"
    Resume ExitSub
 
End Sub

[NeoPa]

When properly linked a subform will find the link to the main form populated for it automatically. However, that is only through the subform's interface - not when done via code directly to another recordset.

Of course, if the subform in question doesn't allow adding new records at all then adding it via the form itself will be a problem in itself. If you're already adding it to .RecordsetClone then you may find adding the FK yourself the easiest option.

[Neruda]

Great thanks, it was bugging me!

[NeoPa]

Never a problem. I love helping people with an interest in Access.