Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    New England (Connecticut)
    Posts
    200
    Thanks
    1
    Thanked 0 Times in 0 Posts

    dlookup not finding records

    All, I have a form that on the on update event of a dropdown list performs a dlookup of a record and populates the rest of the form. The code works great for most of the records but there are several that it will not find. I have done a field by field comparision of records that are found and ones that are not and there are no differences in the data. I have also confirmed that there are no duplicates in the field being looked up. I am using access 2007 with a database that is converted from 2003. Does anyone have any thoughts on this?
    Kevin

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts
    I don't know. In my experience DLookup works reliably. If it seems not to be working I think there must be some difference in the data that you have not been ale to find.

    Can you post a little demo for us to have a look at?
    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
  •