on the main form I have a few combo boxes that a user selects certian choices They will select a product code, and a system. The subform form
will open after the user updates the system field. The subform is based of a configuration table and holds the different chanber configurations per system. Like system 1234 may have ch 1, ch 2, and ch 3 where system 4567 may have ch 1, ch 2, ch 4, ch 5.
Now my problem is that I can't get the right chamber's to show up in the subform. I get all chambers not just the ones for the system selected on the mainform. It appears there not linked correctly but I can't find the problem.
Any help please
jon
will open after the user updates the system field. The subform is based of a configuration table and holds the different chanber configurations per system. Like system 1234 may have ch 1, ch 2, and ch 3 where system 4567 may have ch 1, ch 2, ch 4, ch 5.
Now my problem is that I can't get the right chamber's to show up in the subform. I get all chambers not just the ones for the system selected on the mainform. It appears there not linked correctly but I can't find the problem.
Any help please
jon
