Results 1 to 3 of 3
  1. #1
    TasCat09 is offline Novice
    Windows 10 Access 2016
    Join Date
    Mar 2020
    Posts
    6

    #Name error on one form but not another

    Hello all



    I am confused with my database as I added another field and want the contents of the field to be visible on two forms. The new field works on the single form but I can't get anything other than a #Name error on the continuous form.

    The recordset for both forms is the same (i.e. the name of a single table) and the new field appears in the field list ('show only records in the current record source' and 'show all tables') for both forms.

    I would appreciate any ideas as I can't think of a reason the two forms would be different.

    Thanks heaps

    Mark

  2. #2
    TasCat09 is offline Novice
    Windows 10 Access 2016
    Join Date
    Mar 2020
    Posts
    6
    All fixed. I had an 'on load' event that was passing sql that didn't include the new field.

  3. #3
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Thanks for updating the thread Mark.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Replies: 2
    Last Post: 01-15-2020, 05:51 PM
  2. Replies: 6
    Last Post: 03-17-2016, 02:10 PM
  3. Replies: 14
    Last Post: 03-31-2015, 05:20 PM
  4. Replies: 1
    Last Post: 11-18-2014, 12:35 PM
  5. Replies: 10
    Last Post: 10-22-2013, 07:35 AM

Tags for this Thread

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