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?