Combo Box not saving selection

B

bmoses

I have one combo box on a form that displays information from a table for
selection.

When I add a new record on the form all information (all other fields) are
saved (when I look at the results) except the combo box information. It
shows up empty. Do I need to do something special for the information to be
added to the record when using a combo box?
 
K

Klatuu

Members does not need a category
The form's Record Source is the table or query that provides data for the
form. Forms do not have Row Source or Control Source.
Text Boxes and Combo Boxes have a Control Source. The is the field in the
Form's Record Source the control is bound to. The value in the Control
Source will show in the control and if you change it, it will update the
value in the Record Source.
Combo Boxes have a Row Source. It provides the list of values you can look
up in the combo box. It can be a typed in value list, a query, or a table.
What you have set up here is what is called "Cascading Combos" (Not to be
confused with a musical group from Oregon). The way you need to approach
them is to filter the 2nd combo based on the value in the first combo and the
3rd on the vaule of the 2nd. Then when you update the 1st combo, you need to
requery the 2nd so that only the valid values for the 1st show up, etc.
 
B

bmoses

This seems to be MY main problem (my learning curve). Assistance would be
greatly appreciated.

I have three tables for a many to many situation. (Actually many tables but
I am shortening it here)

Table 1 Members (Has MemberID...does it need a 'Category' field?) I don't
think it should because of the Linkage Table.

Table 2 Linkage Table (Has CatID field and MemberID fields)

Table 3 Category (Has CatID and Category fields)

I'm having a brain issue understanding what the Form Record Source, Control
Source and Row Source's should be??
 
Top