I have four combo boxes in a subform. The first is used to determine values in the second. The second and third are used to determine the values shown in the fourth combo box. How do I prevent the values I've selected in the previous subform record to keep from changing or disappearing when I start making selections in the current subform record.
For instance I will complete a record and move to the next record in datasheet or continuous form view of my subform and when I make my first selection in the first combo box my previous selections will disappear.
Any ideas?
OJ
For instance I will complete a record and move to the next record in datasheet or continuous form view of my subform and when I make my first selection in the first combo box my previous selections will disappear.
Any ideas?
OJ
