Results 1 to 3 of 3
  1. #1
    Twitchie is offline Novice
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2014
    Posts
    20

    Runtime Error After Working Fine Yesterday? Can't find Object.

    So after some great help here with some VBA for conditional formatting, my report was working great yesterday. I run it today and I get a run-time error 2465. It says it can't find the object referred to in the On Load section. The Control Source for the report is a query. It asks the correct question when launching, but then bombs out. Since I turned the calculated fields into Unbound Objects and do the calculations within the VBA instead of each field's Control Source, do I need to define the query or table where the values reside? Thanks!!
    Click image for larger version. 

Name:	Run-Time error 2465.png 
Views:	5 
Size:	34.4 KB 
ID:	15729

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    48,893
    Cannot refer to table or query directly in expression. Would require domain aggregate functions (DSum, DCount, etc).

    If the data is on an open form then need reference like: Forms!formname!fieldname

    I have known references to fields in report RecordSource to fail if the field is not referenced in a textbox on report.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Twitchie is offline Novice
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2014
    Posts
    20
    Heh, I removed the reference to those objects. That's why it started having those issues. I was also using the incorrect syntax. I was trying to do [QueryName].[FieldName] or [QueryName]![FieldName]. Thanks again June7!

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

Similar Threads

  1. Confusing runtime error 424 Object needed
    By RichardAnderson in forum Forms
    Replies: 3
    Last Post: 10-18-2013, 02:32 PM
  2. Runtime Error 424 Object Required
    By Maltheo2005 in forum Programming
    Replies: 9
    Last Post: 06-13-2013, 04:52 PM
  3. Replies: 3
    Last Post: 10-17-2012, 09:24 AM
  4. Replies: 13
    Last Post: 06-12-2012, 09:52 PM
  5. Replies: 3
    Last Post: 04-15-2010, 09:43 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
  •  
Tech Forums: Microsoft Office Forums