Barbara Sherman
New member
- Local time
- Today, 08:06
- Joined
- Jan 27, 2003
- Messages
- 7
Please help. I am working with a form which will have multiple combo boxes and subforms which will interact. On Page 1 of the form the first 2 combo boxes are working perfectly. I used the AfterUpdate property and RowSource to indicate how Access should tie the combo boxes together. However I cannot get the 3rd combo box to work.
1st Combo Box selects a boat manufacturer.
2nd Combo Box selects the model (models shown are based on the manufactuer selected in Combo Box 1).
3rd Combo Box is to select color and color shown will depend on model selected. THIS BOX IS NOT YET WORKING.
There will be a NEXT button on this form page.
The next page should list the motors available for chosen model.
I tried with the 3rd Combo Box to set the property the same as the 2nd box. But it is not showing any colors as I move through the form. I know something is missing.
Any assistance with how to get the 3rd box to relate to the 2nd and so on down the line will be greatly appreciated.
Thank you in advance.
1st Combo Box selects a boat manufacturer.
2nd Combo Box selects the model (models shown are based on the manufactuer selected in Combo Box 1).
3rd Combo Box is to select color and color shown will depend on model selected. THIS BOX IS NOT YET WORKING.
There will be a NEXT button on this form page.
The next page should list the motors available for chosen model.
I tried with the 3rd Combo Box to set the property the same as the 2nd box. But it is not showing any colors as I move through the form. I know something is missing.
Any assistance with how to get the 3rd box to relate to the 2nd and so on down the line will be greatly appreciated.
Thank you in advance.