populating fields with if?

[teiben]

I have a form with fields plant (combo with 5 possible values) and ccost.

I've had to add 5 fields fcost, ccost, bcost, gcost and scost.

I need to populate either fcost, ccost, bcost, gcost and scost to populate depending on the value of the fields plant and cost. What would be the syntax? text box I suspect w/if statement?

Any help would be greatly appreciated.

Thank you

 

[suepowell]

HI

I would put an event procedure on the afterupdate event of plant or cost.

Something along the lines of:

If plant = f
fcost = cost
elseif plant = c
ccost = cost
elseif plant = b
bcost = cost
elseif plant = g
gcost = cost
else
scost = cost
endif

Obviously you need to have the correct logic, and mayce an "if then elseif endif" is not the most efficient.

I hope this points you in the correct direction,

Sue

 

[Rich]

Why 5 separate fields?