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
________
crown comfort
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
________
crown comfort
Last edited: