I have an Access 2000 database whose purpose is to calculate the price of a manufactured product. In one of the forms, a person would select the length of a product and then based on that length, queries (in VBA) would execute and supply values to the form?s combo boxes. This part works. The problem I have is when someone changes the length of the product after filling out the form. When the length changes, other features may changes as well. For example, if the length exceeds a certain number of feet then stronger supports need to be included which would add to the cost. When the value of the length changes, I want the form to update the values in the combo boxes if a change is needed. So far when I try to do this, the box just blanks out. However when I click the drop down arrow, the correct selection is there. Any suggestions on fixing this?
