Results 1 to 2 of 2
  1. #1
    gaker10 is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2014
    Posts
    262

    #Name error on Report's Control Source


    So I have a query that filters a table to one record. I want the data in this query to be thrown into a pre-made report. Query name is ECNQ, and one of the field names is ECN#. I put =[ECNQ].[ECN#] and =[ECNQ]![ECN#] into the report's control source for a text box and get a #Name error. Tried DLookup too. Am I missing something?

  2. #2
    gaker10 is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2014
    Posts
    262
    Solved my own issue I made a blank report and did not give it a report control source. Sorry :3

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

Similar Threads

  1. Replies: 3
    Last Post: 05-03-2014, 03:26 AM
  2. Control source Expression giving #Error
    By N3w2access in forum Forms
    Replies: 5
    Last Post: 01-21-2014, 07:53 AM
  3. Control Source Error ?
    By bellevue in forum Forms
    Replies: 8
    Last Post: 06-02-2012, 12:47 PM
  4. Replies: 5
    Last Post: 10-13-2011, 03:36 PM
  5. Control Source for Text Box (#error)
    By km8415 in forum Forms
    Replies: 3
    Last Post: 06-27-2010, 10:45 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
  •  
Other Forums: Microsoft Office Forums