Results 1 to 4 of 4
  1. 05-20-2011, 12:45 PM #1
    OMGsh Y did I say Yes
    OMGsh Y did I say Yes is offline Novice
    Windows 7 Access 2007
    Join Date
    Sep 2010
    Posts
    22

    Arrow Can someone check my DLOOKUP?

    Happy Friday!

    Can someone take a look at my DLOOKUP and see where my error is coming from? It is working all the way up to [Combo25] but when I added the next "And" is when the trouble started.



    =DLookUp("[Repair Directory]![TAT]","[Repair Directory]","[Repair Directory]![PartNumber]='" & [Forms]![QuoteHeading]![QuoteLineItems2].[Form]![Combo17] & "' And [Repair Directory]![RepairDes]='" & [Forms]![QuoteHeading]![QuoteLineItems2].[Form]![Combo25] & " And [Repair Directory]![Customer]='" & [Forms]![QuoteHeading].[Form]![CustomerID] & "'")

    Thanks!!
    Reply With Quote Reply With Quote
  2. 05-20-2011, 01:05 PM #2
    khalid's Avatar
    khalid
    khalid is offline MS-Access Developer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2010
    Location
    Kuwait
    Posts
    244
    Quote Originally Posted by OMGsh Y did I say Yes View Post
    Happy Friday!

    Can someone take a look at my DLOOKUP and see where my error is coming from? It is working all the way up to [Combo25] but when I added the next "And" is when the trouble started.

    =DLookUp("[Repair Directory]![TAT]","[Repair Directory]","[Repair Directory]![PartNumber]='" & [Forms]![QuoteHeading]![QuoteLineItems2].[Form]![Combo17] & "' And [Repair Directory]![RepairDes]='" & [Forms]![QuoteHeading]![QuoteLineItems2].[Form]![Combo25] & "' And [Repair Directory]![Customer]='" & [Forms]![QuoteHeading].[Form]![CustomerID] & "'")

    Thanks!!
    Check the highlighted quotation...
    Reply With Quote Reply With Quote
  3. 05-20-2011, 01:29 PM #3
    OMGsh Y did I say Yes
    OMGsh Y did I say Yes is offline Novice
    Windows 7 Access 2007
    Join Date
    Sep 2010
    Posts
    22
    Yes!! Thank you....fresh eyes always work! Have a great weekend.
    Reply With Quote Reply With Quote
  4. 05-20-2011, 04:31 PM #4
    khalid's Avatar
    khalid
    khalid is offline MS-Access Developer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2010
    Location
    Kuwait
    Posts
    244
    Quote Originally Posted by OMGsh Y did I say Yes View Post
    Yes!! Thank you....fresh eyes always work! Have a great weekend.
    Great!
    That you got fresh eyes
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. DLookup example
    By pkstormy in forum Code Repository
    Replies: 1
    Last Post: 07-16-2012, 09:52 AM
  2. Need help with dlookup.
    By Keith in forum Database Design
    Replies: 8
    Last Post: 05-24-2010, 06:28 PM
  3. To check or Un-Check all Boxes in a form
    By devcon in forum Forms
    Replies: 7
    Last Post: 05-01-2010, 12:03 AM
  4. Dlookup??
    By Vikki in forum Access
    Replies: 4
    Last Post: 02-16-2010, 07:59 AM
  5. Dlookup
    By janjan_376 in forum Access
    Replies: 20
    Last Post: 07-07-2009, 07:40 AM

Posting Permissions

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

Forum Rules

Other Forums: Microsoft Office Forums