Results 1 to 7 of 7
  1. #1
    chriswrcg is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2018
    Location
    Philippines
    Posts
    142

    How do I fix #name? message in all my form fields

    My data entry form was fine until I finished building it and now when I open it in form view every field has a #name? tag error in it. I am assuming the form no longer knows what table to point to for each entry field but I am not sure how to fix it.

  2. #2
    moke123's Avatar
    moke123 is offline Me.Dirty=True
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Ma.
    Posts
    1,643
    check that you didn't accidentally delete the record source for the form in the property sheet

  3. #3
    chriswrcg is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2018
    Location
    Philippines
    Posts
    142
    The only time I see record source is in the all tab with the selection type set to form. The problem is that my form has multiple tables in it so that I I go to record source and select one of the table it will not fix the overall issue. How to I go to each individual field on the form and tell it what to point back to?

    When I select all the fields that go to one table and tell the form to point to that table then it fixes the error for those fields but not the rest.

  4. #4
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,388
    For simplicity, a general rule of thumb is "One form, One table". Your form apparently has fields wanting to be bound to multiple tables.
    There are workarounds.
    You can make the recordsource of the form a query. Queries can pull fields from multiple tables. This can lead to further problems though, such as a form that will not allow any updates.
    Another workaround is to use the main table as the recordsource for the form, and then use the Dlookup function to pull in fields from supporting tables.
    It would be helpful to see a jpg of your relationship diagram, and a jpg of the form in design view.
    Better yet an upload of your DB in zipped format.
    Last edited by davegri; 10-14-2018 at 12:44 PM.

  5. #5
    GinaWhipp's Avatar
    GinaWhipp is offline Competent Performer
    Windows 7 64bit Access 2013 32bit
    Join Date
    Jul 2011
    Location
    Ohio, USA
    Posts
    377
    Hmm, I think you are saying you are using multiple tables with one Form. Well, that not going to work. So, perhaps you should explain why you are doing it that way? (And it is an odd thing to do.)

  6. #6
    chriswrcg is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2018
    Location
    Philippines
    Posts
    142
    trying to look ahead to my data entry guy and trying to make it simple for him. My original thought was using one form would make it simpler than having three forms up at the same time. I even tried embedding sub-forms into my main form but i kept getting error messages. What is the best way to do it?

  7. #7
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,388
    What is the best way to do it?
    Hard to say with the limited information we have.
    A main form with a tab control holding the three subforms deserves consideration, but again we have little to base a recommendation on.
    Second request: Will you provide the input requested in Post #4?

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

Similar Threads

  1. Replies: 3
    Last Post: 05-13-2018, 12:59 AM
  2. Replies: 4
    Last Post: 02-24-2018, 11:48 PM
  3. Replies: 1
    Last Post: 02-09-2016, 09:03 PM
  4. Replies: 4
    Last Post: 01-14-2016, 02:18 PM
  5. Message for Required Fields in Form
    By tngirl in forum Forms
    Replies: 3
    Last Post: 03-19-2014, 08:25 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