Unanswered: Form with combo boxes that values are repeated, HELP
This will probably be very easy for someone but I'm new at this. I have created a form with four combo boxes on it and a subform that I want to show the results of the combo boxes. It's hard to explain, so I will start at the beginning.
I have 5 tables. Line, machine, bowl, lane, and guage.
Each is related by a unique ID. Line to machine, machine to guage, guage to bowl, bowl to lane.
On my form, I have 4 combo boxes. One for Line, one for machine, one for guage, and one for bowl. Once each of these have a value selected I want the values from the lane table returned in a subform.
The problems I am having is that the values in the combo boxes are all repeated except for the line. There are 3 lines. Each line has 2 machines. Each machine has 3 bowl, and each bowl has 15 lanes. I would like the combo box for line to show the values, "1, 2, or 3". For the machine, "machine1, or machine 2", for guage, "1, 2, or 3", and for bowl "1, 2, or 3".
The values that show up are 1,1,1,1,1,1,1,1,1,1,2,2,2,2,2,3,3,3ect.
I can create the combo box with a list value of my choice, but how to I use this to filter through the table. Also, how do I get the subdata to return from the values entered in the combo boxes?