Results 1 to 2 of 2
  1. #1
    gutenberg is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2016
    Posts
    31

    Adding a combo box gives me an error message

    I am trying to add a combo box to an already created form that will end up printing out on a report. However, when I add the combo box I get an error message stating that: "The specified field '[Program Type]' could refer to more than one table listed in the FROM clause of your SQL statement". I was not receiving this message until I added the combo box. Does anyone have a solution to this issue?

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    in the combo box query, sometimes a field can exist in 2 of the tables.
    you must put the tablename AND the fieldname so the sql wont be confused....

    select tbl1.field from tbl1,tbl2

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

Similar Threads

  1. Replies: 14
    Last Post: 03-31-2015, 05:20 PM
  2. Replies: 2
    Last Post: 02-14-2014, 04:05 PM
  3. Replies: 3
    Last Post: 10-30-2013, 05:59 AM
  4. Combo box error message
    By pbouk in forum Forms
    Replies: 5
    Last Post: 05-08-2013, 07:02 PM
  5. Adding Error Message
    By desibabu90 in forum Forms
    Replies: 3
    Last Post: 08-04-2011, 11:50 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