Cascading Combo Boxes

[jjmartin05]

Hi Everyone,

I'm having some trouble with getting Cascading combo boxes to work on a DB I'm building. I've gotten it to work in prior DB's, but this time it's really frustrating me.

Using Access 2010, on Windows 7 64bit

I have included a link below to access the DB in question, since for some reason, I can't post attachments.

https://dl.dropboxusercontent.com/u/43471904/Lotbooks.zip

I have two tables, tblGradeUNS and tblSpec and the form which contains the cascading combos is subfrmAngle.

Basically, the user will first chose the combo box for "Grade", and then the combo box for "Spec" is supposed to update to only show the records where the "grade" matches.

The code that is being used is:

Private Sub cboGrade_AfterUpdate()
Me.txtUNS = Me.cboGrade.Column(1)

Me.cboSpec.RowSource = "SELECT strSpec FROM" & _
    " tblSpec WHERE GradeID = " & Me.cboGrade & _
    " ORDER BY strSpec"
    
Me.cboSpec = Me.cboSpec.ItemData(0)
End Sub

I really appreciate any help!

Thanks in advance!

 

[SydneyGeek]

You need to requery the second combo to see the updated values.

Change

Me.cboSpec = Me.cboSpec.ItemData(0)

to

Me.cboSpec.Requery

Denis
</pre>

 

[jjmartin05]

Hi Denis,

I updated as you suggested. Then when I choose the option from the first combo box, then when I click on the second combo box, it gives me an error: "Data type mismatch in criteria expression" I'm not sure why, as both the data types are set to "text"

 

[SydneyGeek]

Are they Text in the tables?
And what is the bound column in the first combo? It should be the GradeID (presumably a Long Integer or AutoNumber), and it usually is hidden. If that is the case, set the format of the combo to General.

Denis