Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2006

    Changing the record source in a form

    I have a form that is tied into a table. I have imported a new table that I want to connect this form to. Both tables are the same, the new one is updated info that needs to be changed. This is what I have done.

    In design view (form), form selector, under data - record source, I changed to Product List table, Under the Format tab - changed to Product List. saved.

    Went into form now getting error code: Under all fields #Name?

    Went back into form selector - changed format - record source, back to Products. Still getting the same error:

    I am I missing a step :?:

  2. #2
    Join Date
    Dec 2005
    Wilmington, DE - USA

    Are you absolutely sure that all of the field names in the two tables are identical?

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

Similar Threads

  1. Replies: 0
    Last Post: 11-10-2008, 12:32 PM
  2. Control source and calculated values
    By meistersteff in forum Forms
    Replies: 0
    Last Post: 11-23-2007, 07:04 PM
  3. Form Record Count
    By Texaine in forum Forms
    Replies: 0
    Last Post: 10-19-2006, 09:07 AM
  4. Replies: 0
    Last Post: 08-30-2006, 02:50 AM
  5. Replies: 2
    Last Post: 04-17-2006, 08:13 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