I have a form that has two combo boxes, some text fields, and a subform. I have managed to get the combo boxes to cascade and display the correct information. But their are two problems.
1. The combo boxes only filter the first choice made in combo box one. If you try to update the selections displayed in combo box 2, by making another selection in box 1 it won't update. It will still show the first choices. you have to shut down the form to update the second combo box.
2. This problem is very simliar to the first. How do i update the text fields and subform depending on the selections made in the combo boxes? I haven't got a clue on how to approach this.
It has taken me a lot work to get this far, so any help would be great.
1. The combo boxes only filter the first choice made in combo box one. If you try to update the selections displayed in combo box 2, by making another selection in box 1 it won't update. It will still show the first choices. you have to shut down the form to update the second combo box.
2. This problem is very simliar to the first. How do i update the text fields and subform depending on the selections made in the combo boxes? I haven't got a clue on how to approach this.
It has taken me a lot work to get this far, so any help would be great.
