Results 1 to 3 of 3
  1. #1
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 7 64bit Access 2003
    Join Date
    Feb 2011
    Posts
    1,919

    Report "Can't find field"

    I have a report with a text box bound to a field in the RecordSource, yet Access complains it can't find the field. I'm at a loss as to the source of the problem.



    Here's the text box:
    Click image for larger version. 

Name:	000.jpg 
Views:	5 
Size:	8.2 KB 
ID:	24619

    Here's the text box properties:
    Click image for larger version. 

Name:	001.jpg 
Views:	5 
Size:	38.5 KB 
ID:	24620

    Here's the error:
    Click image for larger version. 

Name:	002.jpg 
Views:	5 
Size:	74.7 KB 
ID:	24621

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    the open event is too soon, try the load, activate or current event. If you google access events, you will see that records have not be loaded when the form opens - it happens later

  3. #3
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 7 64bit Access 2003
    Join Date
    Feb 2011
    Posts
    1,919
    I was going to try a "Load" event, but the report properties doesn't include a "Load" event............... at least not in A2003. Anyway, the "Activate" event worked perfectly.
    Thanks Ajax, I always appreciate your help.
    Bill

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

Similar Threads

  1. Replies: 1
    Last Post: 09-19-2013, 11:42 AM
  2. Replies: 3
    Last Post: 04-22-2013, 06:08 AM
  3. Export "Query or Report" to a "Delimited Text File"
    By hawzmolly in forum Import/Export Data
    Replies: 3
    Last Post: 08-31-2012, 08:00 AM
  4. "Can't find field"error msg
    By gg80 in forum Reports
    Replies: 4
    Last Post: 01-17-2011, 12:46 AM
  5. Error message and How do I find the "value Field" ?
    By createdwithfire in forum Forms
    Replies: 1
    Last Post: 11-05-2009, 12:26 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