Results 1 to 5 of 5
  1. #1
    cbuechner is offline Advanced Beginner
    Windows 10 Access 2007
    Join Date
    Jan 2021
    Posts
    60

    Dlookup


    I have two tables. One table holds parameters (T_Parameters). On this table, it has the MIN and MAX. In another table, holds the test that was completed (T_Rate). I then created a form that is for the T_Rate. In it, there is the "description" of the material being tested as entered for the T_Rate. I want to pull in the parameters into the form header. I dropped a text box and entered

    =DLookUp("[Target_Window_MIN]","[T_Parameters]","[Description]=" & [Forms]![T_Rate]![Description])

    I have done this before, and I cant seam to get this one to work. Im stuck and I didn't expect this to take some much time, since I've seen other examples.

  2. #2
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,388
    Try

    =DLookUp("[Target_Window_MIN]","[T_Parameters]","[Description]='" & [Description] & "'")

    You have Description in both tables? Probably shouldn't be so. Can you show us the relationship diagram of your tables?
    Last edited by davegri; 07-31-2021 at 10:32 PM. Reason: observation

  3. #3
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    Description is a reserved word and should not be used as a field name. Doing so can cause strange errors.

  4. #4
    cbuechner is offline Advanced Beginner
    Windows 10 Access 2007
    Join Date
    Jan 2021
    Posts
    60
    Works....I didnt know description is a reserved word, and I thought actually having the same name helped. I learn more and more from yall. Thank you for the help!

  5. #5
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    there are a lot, common ones are name, date, desc, description

    https://docs.microsoft.com/en-us/off...reserved-words

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Access Dlookup of a Dlookup Assistance
    By caper in forum Access
    Replies: 3
    Last Post: 08-27-2020, 05:56 PM
  2. dlookup with iif
    By pcc in forum Programming
    Replies: 9
    Last Post: 01-16-2018, 02:30 PM
  3. Shortening if / dlookup >0 / then dlookup
    By Jack Russel in forum Modules
    Replies: 1
    Last Post: 02-19-2016, 03:01 PM
  4. DLookup?
    By justravis in forum Access
    Replies: 5
    Last Post: 09-27-2013, 06:54 AM
  5. Dlookup
    By jarvisaurus in forum Queries
    Replies: 4
    Last Post: 01-24-2012, 01:21 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums