Results 1 to 2 of 2
  1. 03-29-2010, 05:08 PM #1
    RickM
    RickM is offline Novice
    Windows XP Access 2007
    Join Date
    Feb 2009
    Posts
    15

    Dlookup in form returns #error

    I have form with a text box where I would like to retreive the value in a field [SumofCost]from a query [qryTotalCostinBox]
    This is what I have in the record source of the text box on the form
    =DLookUp("SumofCost","qryTotalCostinBox")


    It returns #ERROR
    The value it should return is currency.
    Any ideas where my problem is?
    Thanks
    Reply With Quote Reply With Quote
  2. 03-29-2010, 07:59 PM #2
    RickM
    RickM is offline Novice
    Windows XP Access 2007
    Join Date
    Feb 2009
    Posts
    15
    I forgot the [] around the fields
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Form Dlookup macro
    By lukekelly in forum Forms
    Replies: 2
    Last Post: 01-20-2010, 06:24 AM
  2. SELECT returns more than one row
    By 83dons in forum Queries
    Replies: 1
    Last Post: 01-13-2010, 11:28 AM
  3. Dlookup in form doesn't work when I validate a defaultvalue from previous record
    By daniel.preda in forum Forms
    Replies: 2
    Last Post: 11-04-2009, 09:45 PM
  4. You cancelled the previous operation error in dlookup function
    By mhs5466 in forum Forms
    Replies: 2
    Last Post: 11-02-2009, 10:14 PM
  5. Adding 2 Fields together..returns error if no value
    By jhjarvie in forum Forms
    Replies: 4
    Last Post: 09-21-2009, 01:51 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums