Form opening from datasheet, 1st time fine, 2nd time sub-form isblank.

[maxxev]

Hi, I have a datasheet with this code

Private Sub RM_Code_DblClick(Cancel As Integer)
On Error GoTo Err_Command34_Click

    Dim stDocName As String
    Dim stLinkCriteria As String

    stDocName = "frmIngredients"
    
    stLinkCriteria = "[Ing_codeID]=" & Me![Ing_codeID]
    DoCmd.OpenForm stDocName, , , stLinkCriteria

Exit_Command34_Click:
    Exit Sub

Err_Command34_Click:
    MsgBox Err.Description
    Resume Exit_Command34_Click
End Sub

The first time the double click opens the "frmIngredients" form and it's sub-form with no issues.
2nd time (and onwards) the sub-form only is blank.
If I edit the form and come out it complains that it cannot "lock" the form as it is already open (which i'm guessing is relelvent).

Any thoughts please.

Cheers

 

[maxxev]

Nobody have any ideas about this at all?

Anyways I can do it differently then?

Cheers