Results 1 to 5 of 5
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Brookline, Massachusetts, USA
    Posts
    606
    Thanks
    17
    Thanked 0 Times in 0 Posts

    Combo Box Row Source (2003 SP2)

    I have imported a form with subform from another Access db. The Main form is working fine, the subform is not. The subform has a combo box with Row Source from Query2 (Query builder). Query2 has three fields from tblAffiliation: AffilKey (PK), AffilAbbrev, Affiliation. The CB control source is AffilKey. Access error msg says that this control (CB) has an invalid control source. In the original db the control source is AffilKey, with options for the other two fields in tblAffiliation. In the new db there are no options for other fields, leading me to believe that it is "unaware" of tblAffiliation. I deleted Query2 and rebuilt it with same results. What am I doing wrong?

    TblAffiliation is linked to another table, tblNamesAffil with fields NamesAffilI_ID (PK), IDNames (foreign key), AffilKey (foreign key). Field IDNames is also on the subform, displaying correctly.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Combo Box Row Source (2003 SP2)

    If you click the dropdown arrow in the Control Source property of the combo box, is AffilKey one of the fields in the dropdown list?

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Brookline, Massachusetts, USA
    Posts
    606
    Thanks
    17
    Thanked 0 Times in 0 Posts

    Re: Combo Box Row Source (2003 SP2)

    Thanks for the quick response. No, it's blank, no fields listed.
    HH

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Combo Box Row Source (2003 SP2)

    This means that the Record Source of the subform hasn't been set, or not been set correctly.

  5. #5
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Brookline, Massachusetts, USA
    Posts
    606
    Thanks
    17
    Thanked 0 Times in 0 Posts

    Re: Combo Box Row Source (2003 SP2)

    Thanks Hans, that did it.
    HH

Posting Permissions

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