Access Combo Box Question

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • shrike718
    New Member
    • Aug 2007
    • 1

    Access Combo Box Question

    I have 3 tables
    1. Object
    2. Object_Type
    3. Object_Owners

    I have created a master form for Object_Owners with a subform for Object.

    I would like to create a combo box in the subform that shows the current Object_type, and allows the users to change it from the list of possible values from the Object_Types table.


    I've tried this a couple of different ways without success mainly utilizing dragging and dropping of combo boxes onto the subform.
    Is this possible? If so how? I am fairly new to access so I apologize in advance.
  • JKing
    Recognized Expert Top Contributor
    • Jun 2007
    • 1206

    #2
    Please include the MetaData for all relevant datasets. Here is an example of how to post table MetaData :
    Table Name=tblStudent
    Code:
    [i]Field; Type; IndexInfo[/i]
    StudentID; AutoNumber; PK
    Family; String; FK
    Name; String
    University; String; FK
    Mark; Numeric
    LastAttendance; Date/Time
    MODERATOR.

    Comment

    Working...