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.
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.
Comment