Results 1 to 4 of 4

Thread: Dlookup (97)

  1. #1
    4 Star Lounger
    Join Date
    Jun 2001
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Dlookup (97)

    Dlookup
    I

  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: Dlookup (97)

    Try

    intCollCod = DLookup("Code", "Collections", "Title = ' " & Me.Title & "'")

    assuming title is a string. Not there is an apostrophe ' after the = amd at the end another one between the two double quotes.
    Regards
    John



  3. #3
    4 Star Lounger
    Join Date
    Jun 2001
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Dlookup (97)

    Yep that did it, thanks John!

  4. #4
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Dlookup (97)

    You might want to keep this link handy, I do!!!!

    DLookup Usage Samples

Posting Permissions

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