Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2011
    Location
    Chicago
    Posts
    37

    Question Unanswered: Trying to fix the Name field

    I'm currently building a DB on Access 2007 for work and need help with the name field displaying #Name? instead of the employee name chosen. The record source has a name field added to the table. The Employee ID shows up when selecting an employee, but the name doesn't. I've attached a screenshot to give an idea what the form looks like. Let me know if you need additional info. Thanks a lot for the help.
    Attached Thumbnails Attached Thumbnails form edit.JPG  

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    that error appears when you have assigned a column name to a control, as the controls datasource and the Access runtime does not know what this datasource is

    go back and check your spelling
    go back and make certain the column name actually matches what is in the underlying query or table
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •