Results 1 to 2 of 2
  1. 03-27-2011, 01:26 PM #1
    Jackie
    Jackie is offline Novice
    Windows Vista Access 2007
    Join Date
    Mar 2011
    Posts
    15

    Problems with DSum

    Hi Guys


    I have a form "JobForm1" with a sub form "JobSubForm1" and I am trying to do a Dsum to look up the total Balance from another table
    the code I am using is:
    Code:
    Me.Balance = DSum("[TotalDebit]", "Activity", "[JobID] = '" & Forms![JobForm1]![JobSubForm1]![JobID] & "'")
    but I can't get it to work
    any ideas?
    Cheers
    Jackie
    Reply With Quote Reply With Quote
  2. 03-27-2011, 05:21 PM #2
    RuralGuy's Avatar
    RuralGuy
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    This link shows how to reference objects through the Forms collection:
    http://www.mvps.org/access/forms/frm0031.htm
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Help with Sum and DSum
    By objNoob in forum Reports
    Replies: 5
    Last Post: 12-05-2011, 01:55 AM
  2. How do I use the DSum
    By Ironclaw in forum Access
    Replies: 1
    Last Post: 08-25-2010, 07:35 AM
  3. Help with dsum
    By bjsbrown in forum Reports
    Replies: 6
    Last Post: 02-06-2010, 09:33 AM
  4. DSUM HELP needed
    By jjmartinson in forum Access
    Replies: 0
    Last Post: 07-21-2009, 01:47 PM
  5. DSUM Problems
    By swampdonkey in forum Forms
    Replies: 2
    Last Post: 09-29-2006, 10:52 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