Form Adding record not Editing

[Steven19]

I have a form issue.



I have a sub form that, when on its own will let me click the edit button and the appropriate form will come up and the selected record will let me edit it.

However this form is actually a subform and when it is on the main form. I click that same edit button and instead it desnt edit, but only allows me to add a record.

I've played with the onclick command and it is presently thus:

Private Sub Editbtn_Click()
DoCmd.OpenForm "CompanyDirectorsMultiE", acNormal, , DirectorsofCompanyID = "Me.DirectorsofCompanyID", acFormEdit, , CompanyDDID
End Sub

Yet I'm struggling to work out wh.

The form I'm opening has the following code:

Private Sub Form_Load()
Me!CompanyDDID = Me.OpenArgs
End Sub

Would you know why when its part of a main record the edit button doesnt upen my form in edit mode the same wayy when it is stand alone?

[June7]

I am confused about what is opening which from where. If you want to provide db for analysis, follow instructions at bottom of my post.

[Gicu]

I think you have some issues with the code:

Private Sub Editbtn_Click()
'DoCmd.OpenForm "CompanyDirectorsMultiE", acNormal, , DirectorsofCompanyID = "Me.DirectorsofCompanyID", acFormEdit, , CompanyDDID
DoCmd.OpenForm "CompanyDirectorsMultiE", acNormal, , "[DirectorsofCompanyID] = " & Me.DirectorsofCompanyID, acFormEdit, , CompanyDDID
End Sub

Private Sub Form_Open(Cancel As Integer)
'openargs available in Open event not Load
Me!CompanyDDID = Me.OpenArgs
End Sub

Is the main form allowing edits (AllowEdits= True)?

Cheers,