Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2016
    Posts
    16

    Unanswered: Adding a combo box gives me this 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
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Define the table
    Eg
    [Mytable].[program type]
    Or when defining the query that joins the tables give the columns an alias
    Select a.mycol as amycol, b.mycol as bmycol from atable as a
    Join btable as b on b.mycol = a.mycol
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •