Results 1 to 2 of 2
  1. #1
    anoob is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Jan 2011
    Posts
    60

    Sum Error on Split Form

    Hello,
    I hope this is not too vague a question. I have a few unbound fields in the footer and header of my split form. All I would like to do is have them display the sums of certain fields, but I am getting an #Error.

    The form can be seen here:
    http://www.hangnailproductions.com/SumError.jpg

    My Control is just
    Code:
    =Sum([Transaction_ID])
    These are unbound fields.
    For some reason this type of field worked on a normal form I had created, but not on the split form they don't seem to get... well, anything.

    Any idea why this is?

    (On a side note, I added a BG image to the Details section, and when I look at the hide/unhide list I now have an option to check "image24" on or off - which is odd. When I check it it shows up in the datasheet as an ampty column with the column title "Image24". I don't know if there is a way to prevent this image from being included on this list?)

    Many thanks!

  2. #2
    anoob is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Jan 2011
    Posts
    60
    Ok problem solved - the field in the top right had a control source that was not resolving correctly, and it was causing every unbound field to show an #Error - but when I deleted the problem they all started to work.

    Thanks.

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

Similar Threads

  1. Modifying a Split Form?
    By robertrobert905 in forum Access
    Replies: 0
    Last Post: 10-26-2010, 08:00 AM
  2. Database Split - Error Subscript out of range
    By Huddle in forum Database Design
    Replies: 7
    Last Post: 07-16-2010, 01:52 PM
  3. Replies: 0
    Last Post: 03-27-2010, 01:25 PM
  4. Split Form not working correctly
    By Brian62 in forum Access
    Replies: 29
    Last Post: 02-16-2010, 05:43 PM
  5. Split Form Sync up
    By jonsuns7 in forum Forms
    Replies: 1
    Last Post: 11-10-2009, 02:56 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