Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Aug 2008
    Location
    Daytona Beach, Florida, USA
    Posts
    42
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Dlookup in Macro Error 2950

    Everytime I run the following Macro in a form field after update I receive the Error 2950 message box.

    Dlookup Macro.JPG

    Item [EmployeeID]
    Expression DLookUp("[Employee ID]","Contacts Extended","[File As]=" & [FULLNAME])

    I am trying to update the EmployeeID field with the Employee ID from the Contacts Extended Query when the FULLNAME field is updated - FULLNAME from the form equals File As in the Contacts Extended query

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts
    Unfortunately we will need to know a fair bit more about your application in order to assist you with this. Can you create a slimmed down and de-personalized version of your database that will let us see the tables and queries involved in your problem? If you can, post a reply and attach the compacted and zipped version to your reply.
    Wendell

  3. #3
    Lounger
    Join Date
    Aug 2008
    Location
    Daytona Beach, Florida, USA
    Posts
    42
    Thanks
    3
    Thanked 0 Times in 0 Posts
    Disregard my post I just figured it out!!!

Posting Permissions

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