M
MCB
I have a form on which I want to employ a filter so that the record selected
in cboDepartment determines which records are displayed in three other combo
boxes: cboAssociate, cboTeamLead and cboIssueCategory. Then I need a second
filter so that the record selected in cboIssueCategory determines which
records are displayed in cboIssueSubcategory. The user can then select the
correct records from these combo boxes in the course of building an issue
record (the form all of these fields are on is frmIssues).
I have not been able to get this working correctly. The most common problem
is that when I create a new issue record, save, then close the form, when I
re-open the form and go to the issue record I just created, some of the
fields are appearing blank. I can get the form working fine if I don't add
any filters, but as some combo boxes have a lot of records, it would make
life a lot easier if this would work. I've tried multiple query
configurations, bound combo boxes, unbound combo boxes, etc.
In addition, a couple more spanners in the works:
1) I have several many-to-many relationships and their junction tables
involved. (Multiple departments use the same issue categories, for one.)
2) The record selected in cboDepartment determines if cboSubdepartment is
enabled or disabled. This works, but I don't know how to add more code for
cboDepartment "around" the After_Update() sub-routine that's there.
Hope that makes sense. Any assistance is greatly appreciated. However, I
warn you that I have almost zero experience working with VBA, so there's a
good chance just posting a chunk of code won't help me unless it's
accompanied by explanation.
in cboDepartment determines which records are displayed in three other combo
boxes: cboAssociate, cboTeamLead and cboIssueCategory. Then I need a second
filter so that the record selected in cboIssueCategory determines which
records are displayed in cboIssueSubcategory. The user can then select the
correct records from these combo boxes in the course of building an issue
record (the form all of these fields are on is frmIssues).
I have not been able to get this working correctly. The most common problem
is that when I create a new issue record, save, then close the form, when I
re-open the form and go to the issue record I just created, some of the
fields are appearing blank. I can get the form working fine if I don't add
any filters, but as some combo boxes have a lot of records, it would make
life a lot easier if this would work. I've tried multiple query
configurations, bound combo boxes, unbound combo boxes, etc.
In addition, a couple more spanners in the works:
1) I have several many-to-many relationships and their junction tables
involved. (Multiple departments use the same issue categories, for one.)
2) The record selected in cboDepartment determines if cboSubdepartment is
enabled or disabled. This works, but I don't know how to add more code for
cboDepartment "around" the After_Update() sub-routine that's there.
Hope that makes sense. Any assistance is greatly appreciated. However, I
warn you that I have almost zero experience working with VBA, so there's a
good chance just posting a chunk of code won't help me unless it's
accompanied by explanation.