Cascading Combo Box Help

[euphoricdrop]

I have a form, frmRepair, that has two combo boxes on it (cboModelNumberID & cboPartNumberID). I would like to have the user select from cboModelNumberID and have it filter results for cboPartNumberID. I currently have the filtered results coming from three seperate tables depending on the model number selected. (tbl1060PartNumber, tbl1063PartNumber, tbl1073PartNumber).



Following is the code I used:
Private Sub cboModelNumberID_AfterUpdate()
On Error Resume Next
Select Case cboModelNumberID.Value
Case "1060"
cboPartNumberID.RowSource = "tbl1060PartNumber"
Case "1063"
cboPartNumberID.RowSource = "tbl1063PartNumber"
Case "1073"
cboPartNumberID.RowSource = "tbl1073PartNumber"
End Select
End Sub

According the some cascading combo box tutorial sites, my code appears ok. The problem is when I select from cboModelNumberID, nothing appears in cboPartNumberID to select from. It is blank. Please help, what am I doing wrong?

[ssanfu]

In design view, look at the properties for cboPartNumberID. On the FORMAT tab, look for a line "Column Count".
What is the number there?
Then look for "Column Widths". This is where you show or hide columns. To hide a column, set the width to zero.

To hide the first column and show the second column, use 0;1.2

[euphoricdrop]

I tried to adjust the columns in various way, but there is still nothing.

[ssanfu]

I created a temp mdb and the code worked as expected. Can/would you upload your mdb (minus any sensitive info)??