Question about Combo Controls

[dragongunner0351]

I have a Form with an embedded subform. The subform is in Datasheet view, one of the controls is a Combo Control when I select the part the Base Price associated with the part autofill on the subform but the sale price and units on hand do not. Any ideas why?

 

[rjoubert]

This might be a stupid question, but have you gone into the Design view for the subform to verify that the Control Source for each of your fields is correct? If you're updating these fields through code, have you verified that you're referencing the correct field names?

 

[dragongunner0351]

Thanks for the reply, Not a stupid question. First, I didn't make this particular part of the system so Im not 100% on exactly what the guy before me was trying to accomplish. Although it looks like it was an Orders Template from the Microsoft Website. The order details table and the products table have some matching fields however the only one that updates is the base price field. Back to your org question I will go and check all of the control sources and make sure they are correct