textbox not refreshing

[T]

I'm stuck and would appreciate help. I have a field called plant,
(combobox) that list 4 plants, another field called customercost and
one field for MIcost, GAcost, LAcost and OG cost.
Whenthe user selects a plant and enters a customercost the afterupdate
on the customercost using an if then else statement populates the
correct cost field. The problem is if the user orgianlly enters the
plant as MI MIcost doesn't refrish with change. I've played around
with the refresh statement on te Plant but I keep getting errors.

[Tom van Stiphout]

On Tue, 18 Sep 2007 15:40:16 -0700, T <te****@wideopenwest.comwrote:

If I understand you correctly one of the 4 fields should be populated
when TWO fields are populated, and recalculated when ANY ONE of those
two fields' value changes.
So it is not enough to write code in the CustomerCost.Afterupdate.
Rather you would take that existing code and put it in a procedure
that you call from CustomerCost.Afterupdate as well as
Plant.Afterupdate.

-Tom.

>I'm stuck and would appreciate help. I have a field called plant,
(combobox) that list 4 plants, another field called customercost and
one field for MIcost, GAcost, LAcost and OG cost.
Whenthe user selects a plant and enters a customercost the afterupdate
on the customercost using an if then else statement populates the
correct cost field. The problem is if the user orgianlly enters the
plant as MI MIcost doesn't refrish with change. I've played around
with the refresh statement on te Plant but I keep getting errors.

[OldPro]

On Sep 18, 5:40 pm, T <[e-mail]:

I'm stuck and would appreciate help. I have a field called plant,
(combobox) that list 4 plants, another field called customercost and
one field for MIcost, GAcost, LAcost and OG cost.
Whenthe user selects a plant and enters a customercost the afterupdate
on the customercost using an if then else statement populates the
correct cost field. The problem is if the user orgianlly enters the
plant as MI MIcost doesn't refrish with change. I've played around
with the refresh statement on te Plant but I keep getting errors.

First of all, the extra cost fields are redundant and create extra
work without additional benefit. A simple SQL query can easily
retrieve the cost of any plant by filtering by plant type.
Second, a lookup should be triggered by the field that it is based
on. If it is based on two or more fields, then a change to any of
these should trigger a routine that a) validates that all of the
required fields have been input, and b) does the lookup.