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?

__________________
Mitch

Hi!
If u use the filter as a data entry form, use an edit form to see all records
after the update.
Regards Penta.

Mitch,
Try the suggestion I gave Chantal with similar problem.
John