Irish_Wertzy
New member
- Local time
- Today, 16:12
- Joined
- Feb 19, 2012
- Messages
- 2
I have a form with two cascading comboboxes. You select a responsible department in the first box, and then select a job function in the second box.
When I choose a department, the value that gets entered into the table associted with the form is the autonumber, and not the department code.
Not really a problem, but when I run my pivot table and try to filter by department, the number and not the dept name shows up.
I will attach the database in a zip for reference.
The form in question is frmErrorEntry and the combobox is cboResp (that feeds cboFunction). The table in question is Certification Error (I know it is not named in the proper convention, I will fix that separately).
When I choose a department, the value that gets entered into the table associted with the form is the autonumber, and not the department code.
Not really a problem, but when I run my pivot table and try to filter by department, the number and not the dept name shows up.
I will attach the database in a zip for reference.
The form in question is frmErrorEntry and the combobox is cboResp (that feeds cboFunction). The table in question is Certification Error (I know it is not named in the proper convention, I will fix that separately).
