The following is a simplified version.
I have a table called tblOps with the following fields:
OpsID; Dept; Section
The data entry for the fields 'Dept' & 'Section' is done from combo boxes.
The combo boxes are based on tables:
tblDept with fields: DeptID; DeptName
tblSection with fields: Section ID; Section Name
In each case when the selection is made, the ID is entered into the table, not the Name.
I have a form for this the tblOps and would like to be able to filter the records with a combo box. When I use the Combo Box Wizard, of course the choices in the list show only the ID numbers not the Names in the fields. This is not useful for the end users, since they don't know all the ID numbers.
I've made a combo box based on a query that includes, the not only the tblOps, but also has linked the tables tblDept & tblSection.
In this query I have selected the following fields to create the drop-down list:
OpsID; DeptName; SectionName
The combo box works on my form with a usable drop-down list, but does not filter my records. How do I get it to filter the records in my form?
Am I on the right track? Can I filter the records in a form using a combo box based on a query?
Thanks ahead of time, if anyone can help me.