DblClk to open form

[d9pierce1]

Hi all,


I have a form field that has a dblclk to open a form for editing. Currently it open form and shows all records and what I am asking is there a way to get this to open the form to just specific businessID?

Private Sub CboReference_DblClick(Cancel As Integer)
    Dim LinkCriteria As String
        LinkCriteria = "[ReferenceName] = '" & Me!CboReference.Text & "'"
    DoCmd.OpenForm "frmReference", , , , , , Me.CboReference
    
End Sub

Something like DoCmd.OpenForm "frmReference" Where BusinessID = BusinessID so that when that form opens up to edit i only see the References from that business

Thanks
Dave

[d9pierce1]

Update,
I was able to do this task by creating a query although still interested if this can be done by code in the dblclk function?

[CJ_London]

you've created your link criteria but haven't used it in your where parameter

you just need to extend it to include businessID

LinkCriteria = "[ReferenceName] = '" & Me.CboReference & "' AND [BusinessID]=" & me.businessID


note better to use . than ! so you can get the benefit of autocomplete. Plus using ! late binds the value so it won't create an error on compilation (if there is one) but will on run. And you don't need to use the .text property

[d9pierce1]

thank you so much