Related Combo Boxes

[Michael T]

Hi,



How do I get combo2 box to only show related records from what has been selected from Combo1 box?

Thanks

Michael

[RuralGuy]

It is called Cascading ComboBoxes or Cascading Lists. Try searching on it. Here's some links to get you started:
http://www.datapigtechnologies.com/f...combobox2.html
http://www.fontstuff.com/access/acctut10.htm

[Michael T]

Thanks RuralGuy,

I have followed the data pig solution but combo box 2 is always empty, I have checked my query and made sure combo box 1 re-queries combo box 2. Any suggestions?

Michael

[RuralGuy]

Can you get ComboBox 2 to display a generic list?

[Michael T]

If I remove the statement whereby I'm looking at the two fields checking if they match I get a list of everything, when I put the criteria in I get nothing.

[RuralGuy]

Meaning nothing matches your criteria. What are you using as a RowSource in ComboBox2 after ComboBox1 has been updated?

[Michael T]

Do you mean what command (sorry I'm a novice).

If so I'm using requery for combo box 2:

Private Sub Combo11_AfterUpdate()
Combo13.Requery
End Sub

[RuralGuy]

In that case, what is the SQL for the RowSource of ComboBox2?

[Michael T]

SELECT [Package Ids].Package FROM [Package Ids] WHERE ((([Package Ids].[Appeal Description])=forms!source.combo11)) GROUP BY [Package Ids].Package ORDER BY [Package Ids].Package;

[RuralGuy]

Okay, then what is the SQL for the RowSource of ComboBox1 and what is the BoundColumn and the ColumnCount?

[Michael T]

Rowsource combo box 1:

SELECT [Appeal Desc].[Appeal ID], [Appeal Desc].[Appeal Desc] FROM [Appeal Desc] ORDER BY [Appeal Desc];

Bound column = 1

Column count = 2

[RuralGuy]

So it looks like you are trying to get records in cbo2 where
[Package Ids].[Appeal Description] = [Appeal Desc].[Appeal ID]
...do you think that will work?

[Michael T]

No, I'm trying to get records in cbo2 where:
[Package Ids].[Appeal Description] = [Appeal Desc].[Appeal Desc]
Isn't that what I'm doing?

[Michael T]

OK, I see it, Thanks for your help!

[RuralGuy]

Glad we could help. Happy Turkey day.