dependent comboboxes not allowing choices in the second combobox

[Les W]

I am having trouble with my drop down list in a second combobox. I have 3 tables as follows:

Table 1: s, fields: Source _ID(pk), Source _Name
Table 2: w, fields: Location_ID(pk), Location_Name
Table 3 (junction table): sw, fields: SW_ Source _ID(pk), SW_Location_ID(pk)

I have 2 comboboxes on my form: cbo1 and cbo2. Cbo2 is dependent on the value in cbo1.

Cbo1 has the following RowSource stmt:

SELECT [s].[Source _ID], [s].[Source _Name] FROM s;

Cbo2 has a query as the RowSource. The query stmt is:

SELECT sw. SW_ Source _ID, w. Location_Name
FROM s INNER JOIN (w INNER JOIN sw ON w.Location_ID = sw. SW_Location_ID) ON s. Source_ID = sw.SW_Source _ID
WHERE (((s.Source_ID)=[forms]![Form1]![cbo1]));

Cbo2 will correctly display the drop down list associated with the choice in cbo1. The problem is that no matter which item in the cbo2 item list I choose, cbo2 will only show the first item in the list. For example, if the drop down list is A, B, C, D and I choose item C, item A shows as my choice. What I want is to show S_Name in cbo1 and it’s corresponding list of names as W_Name in cbo2 (which it does) and the ability to choose item B or C or D.

I do have a Requery AfterUpdate of cbo1, which works fine i.e. the list in cbo2 does change when the cbo1 selection changes.

[ranman256]

check if cbo2.bound column is correct.

sometimes it will do this.

[Les W]

okay, I had the bound column to 1 and changed it to 2. Now it does give me the choice - thank you. But, in my processing of the contents, I need the Location_ID number, not the name. When I check the value in cbo2 (debug) it does give me the text value of, say 'C'. I think I could now use DLookup to get the value from Location_ID. Is there another way to have cbo2 return the number from field 1? I hope this is clear.

[orange]

cross posted http://www.access-programmers.co.uk/...d.php?t=281278

[Les W]

I have no problem when there is a simple relationship between 2 tables. The problem has only come up when there is a many-to-many relationship with a junction table.