change CBO value from another CBO

[kawi6rr]

First I know catagory is spelled wrong but that's how its spelled in the DB.

I have 2 combo boxes, the first is a cbo_catagory the second is cbo_topic. After update of cbo_catagory I want cbo_topic's value to be based off what was selected from cbo_catagory.

Private Sub cbo_Catagory_AfterUpdate()
Dim strSQL As String
strSQL = "SELECT DISTINCT CFS_Export.Topic, CFS_Export.Catagory FROM CFS_Export WHERE CFS_Export.Topic = '" & Me.cbo_Catagory & "'"
Me.cbo_Topic2.RowSource = strSQL
Me.cbo_Topic2.Requery
End Sub

As of now nothing happens, any help is apprecaited.

 

[jdraw]

see
http://www.datapigtechnologies.com/flashfiles/combobox1.html
http://www.datapigtechnologies.com/flashfiles/combobox2.html

It's 2003 but the concept is the same.

 

[kawi6rr]

The second link was exactly what I needed, thanks.