jjmartin05
New Member
- Joined
- May 19, 2011
- Messages
- 5
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:
I really appreciate any help!
Thanks in advance!
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:
Code:
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!