Results 1 to 2 of 2
  1. #1
    Join Date
    May 2011

    Unanswered: DLookup for Attachments

    The scenario: In tblPeople I have the fields "ID", "Full Name", "Profile Picture", and "Friends"- with the "Profile Picture" column being an attachment and the "Friends" column being a multi valued field based on the "ID" column. What I am trying to do is develop a form that will present a list of all of an individual's friends- to include "Full Name" and "Profile Picture."

    Using a query, I am able to create a form that will generate the individual's ID and the ID of each of their Friends. Using the DLookup feature, I can then create a text box that display's the Friend's "Full Name." I cannot seem to get DLookup to work for the "Profile Picture" attachment. Any suggestions on how to make it work, or another method for generating this form?

  2. #2
    Join Date
    May 2010
    Why are you having to use DLookup()?

    Why not set the form's record source to a query tht gets all the data you need? No DLookup required.
    Boyd Trimmell aka HiTechCoach (free access stuff)
    Microsoft MVP - Access Expert
    BPM/Accounting Systems/Inventory Control/CRM
    Programming: Nine different ways to do it right, a thousand ways to do it wrong.
    Binary--it's as easy as 1-10-11

Posting Permissions

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