I have a form with a subform that I want the 2 combo boxes to work like this.
combo1 (List of part groups)Ignitors, Gas Valves, Filters
combo2 (partNumbers) IGN001,IGN002,GV001,GV002,FLT001,FTL002
textbox (Description of part) [Trane Ignitor 1234] or [trane gas valve] or [pleated filter].
If i choose ignitors in combo1, then in combo 2 I only want the ignitors part numbers to show up. and automatically fill in the text box (description). i have this working on a single form but when i try to do this on a sub form it does not work.
combo1 (List of part groups)Ignitors, Gas Valves, Filters
combo2 (partNumbers) IGN001,IGN002,GV001,GV002,FLT001,FTL002
textbox (Description of part) [Trane Ignitor 1234] or [trane gas valve] or [pleated filter].
If i choose ignitors in combo1, then in combo 2 I only want the ignitors part numbers to show up. and automatically fill in the text box (description). i have this working on a single form but when i try to do this on a sub form it does not work.