This Form is driving me mad!!

[Josh]

Hi, I am working on a form that uses 3 combo-boxes that are linked to
populate only with the data that is related to them (basing value of control
on another control).
Here is an example... model # is selected, the color box is populated with
the colors that are available for that model #. Once the color has been
selected, the accessory packages available for those models in those colors
are populated in this combo box. I have not had any
issues up to this point, but the problem comes in when I try to populate a
text box with the price for this specific buildout. I want it to be in a
text box so that if this changes, anyone can easily click through the combo
boxes and update the
price. All of the data is being pulled from one table.

Any suggestions as to how to go about doing this would be greatly
appreciated. Let me know if any further explanation is required.

 

[Josh]

Thank you so much for your response...

I just have one question. The combo boxes correctly update based on what
selections are made, but the textbox field that I wish to include so that
people can update the prices as they change does not update. Based on the
first buildout that is selected, the textbox is updated, but after that it
does not. Is it possible to fix this problem?

Thanks,
Josh