Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Apr 2005
    Location
    Plovdiv
    Posts
    109
    Thanks
    0
    Thanked 0 Times in 0 Posts

    On Current (Access 2000)

    Can you help me ? In my form Customers i have a memo field called Sigma, and i want when there is something written in in, to open a pop from showing the details for this customer.
    I tried to put it in the onCurrent event of the form but i do not know the right way to do it.
    I have written the following in the on curent event :

    Dim stDocName As String
    Dim stLinkCriteria As String
    stDocName = " PopuUpCustomers"
    stLinkCriteria = "CustomerID = Forms![PopUpCustomers]!CustomerID"
    If Me!Sigma > 0 Then
    DoCmd.OpenForm "PopUpCustomers"
    else
    exit sub
    end sub

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: On Current (Access 2000)

    Try

    Dim stDocName As String
    Dim stLinkCriteria As String
    stDocName = " PopuUpCustomers"
    stLinkCriteria = "[CustomerID] = " & me!CustomerID
    If not isnull(Me!Sigma) Then
    DoCmd.OpenForm stDocame,,,stLinkCriteria
    else
    exit sub
    end sub

    This assumes customerID is a number
    Regards
    John



Posting Permissions

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