Combox not showing data when criteria is changed
I have a continuous subform that has a combobox in the detail that shows TOOLS, in the subform Header I have a combobox called TOOL_TYPE.
I have the user select the TOOL_TYPE which is used to filter the query in TOOLS. This works fine, but my problem is how do I show the data in all the records that have allready been selected when they don't match the criteria in TOOL_TYPE ?
For example: the previously selected entries might be one of each: Taps, Inserts, Counter Sinks. If on the new record they select TOOL_TYPE = Drills then all the comboboxs for the previous records go blank because they are not Drills.
Right now the only thing I can think of is putting a field on top of the combox that actually does a DLOOKUP.
Any better solutions?