Good day,

I am using the Cascading Combo Boxes on my form and I want to add the "Number Value" of my boxes to my table and not the Text value. The setup of my boxes is:
tblcategory
- categoryid
- CategoryName

tbltype
- typeid
- typeName
- categoryid

tbldetail
- detailid
- detailName
- typeid
- categoryid

The SQL that I am using is

Dim SqlStr As String


SqlStr = "INSERT INTO tblclose (casenum, category, type, detail) Values" _
& "('" & Forms!frmupdate!frmupdatesub!casenum & "', '" & Forms!frmupdate!frmupdatesub!cbocat & "', '" & Forms!frmupdate!frmupdatesub!cbotype & "'," _
& "'" & Forms!frmupdate!frmupdatesub!cbodetail & "', #")"

DoCmd.RunSQL (SqlStr)

The values of combo boxes do not be entered(just blank), just the casenum. Just wondering if anyone can help me out and tell me how I can "Lookup" the values of the combo id's in the corresponding tables!
Hopefully this is clear!

Thanks