A little relevant background: I have 3 tables (tblncident, tblClassification, and an associative tblIncidentClass). I currently have a form with tabs, and on each tab I have a subform linked under master fields with a field titled "InternalIncidentID" so that as I go through InternalIncidentIDs the subforms on the tabs change accordingly.
One of my tabs with a subform currently has a combo box where the user can select ClassificationName (a field in tblClassification), and unseen in the background the InternalIncidentId (PK of tblIncident) and the ClassificationID (PK of tblClassification) are written to the associative table (and are the table's composite PKs).
Instead of this approach (which does work), the user wants me to remove the combo boxes and use check boxes to present all 20-25 ClassificationName options instead. This is a bit of a challenge for me, as I am still somewhat of a beginner in Access. I need help with the programming, as I need to somehow use the checkbox Yes/No value and assign the appropriate ClassificationID and InternalIncidentID to the table in the background. The user also needs to be able to check as many of the boxes as possible. I would really, really appreciate some help and guidance on the code since I am a relative newbie when it comes to VBA. Thanks in advance!
One of my tabs with a subform currently has a combo box where the user can select ClassificationName (a field in tblClassification), and unseen in the background the InternalIncidentId (PK of tblIncident) and the ClassificationID (PK of tblClassification) are written to the associative table (and are the table's composite PKs).
Instead of this approach (which does work), the user wants me to remove the combo boxes and use check boxes to present all 20-25 ClassificationName options instead. This is a bit of a challenge for me, as I am still somewhat of a beginner in Access. I need help with the programming, as I need to somehow use the checkbox Yes/No value and assign the appropriate ClassificationID and InternalIncidentID to the table in the background. The user also needs to be able to check as many of the boxes as possible. I would really, really appreciate some help and guidance on the code since I am a relative newbie when it comes to VBA. Thanks in advance!