Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2010
    Posts
    39

    Unanswered: stLinkCriteria parameter issue

    I have a stLinkCriteria piece of coding that is used to launch from a list box a new form that should populate the new form with the record. However, when the record in the list box is double clicked to perform this action I get an enter parameter value box pop up that should be drawing from my RCID field. As im not great with code, can someone point me in the right direction please? Thanks

    Code:
    Private Sub SearchResults_DblClick(Cancel As Integer)
        
        Dim stDocName As String
        Dim stLinkCriteria As String
    
        stDocName = "FRM_Query"
        
        stLinkCriteria = "[RCID]=" & Me![SearchResults]
        DoCmd.OpenForm stDocName, , , stLinkCriteria
        
    End Sub

  2. #2
    Join Date
    Jan 2010
    Posts
    39
    ignore me.. being silly and didnt change the bound column ARGH!

  3. #3
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    You're ignored!

    It's always better when you can figure it out for yourself, isn't it?
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •