Results 1 to 3 of 3
  1. #1
    dulworth is offline Novice
    Windows 8 Access 2010 64bit
    Join Date
    Feb 2013

    Adding new field to existing table and form - getting error

    I'm trying to add a combo box field to an existing table and form. I added the new field to my existing table and set it up as an combo box added my row sources. Then added the new field to an existing form and now am getting a error stating "The record source "Table name and added field here" specified on this form or report does not exist. When I just make the new field a text box instead of combo box it works just fine. Any help would be appreciated. Thanks - TD

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Quote Originally Posted by dulworth View Post
    ...and set it up as an combo box...
    What you did here is create a Look Up Field at the Table Layer. This technique is rarely used. The best approach is, usually, to create a field in your table of Long Integer type and store Primary Key values from another table in your new field. For example, a combo on a form would have a value of, say, 5. You would store "5" in your new field in the table. The Key value of 5 would represent a Record/Row in another table or a Value List within a combo.

  3. #3
    dulworth is offline Novice
    Windows 8 Access 2010 64bit
    Join Date
    Feb 2013
    Ok, I will try your suggestion. Thank you, for your help. - TD

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

Similar Threads

  1. Replies: 7
    Last Post: 05-13-2014, 10:07 AM
  2. Replies: 29
    Last Post: 04-25-2014, 03:49 PM
  3. Adding existing field to query returns blank
    By kaitlinquinn in forum Queries
    Replies: 5
    Last Post: 04-23-2014, 02:43 PM
  4. I am stumped...adding field to existing table
    By tanyalee123 in forum Queries
    Replies: 6
    Last Post: 12-09-2013, 06:04 PM
  5. Adding records to existing table
    By Mclaren in forum Programming
    Replies: 5
    Last Post: 05-18-2011, 12:44 PM

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