User Editable Price Field flows through to calculations

[mindbender]

I have a form that has the following set up


Is it possible to have the Custom Price field editable by the user so that if they populate it, it multiples by the QTY1 field value and overwrites the Total Base Price Field. The BasePrice1field is originally populated from the columns returned by the row source of the cbx_term1 field and then multiplied by the value the user enters into field QTY1 to populate the Total Base Price field

[Bob Fitz]

Try:
=IIF(IsNull([Custom Price],[BasePrice1]*[QTY], [Custom Price]*[QTY])
as the ControlSource property of "Total Base Price" instead of =[BasePrice1]*[QTY]

[mindbender]

Try:
=IIF(IsNull([Custom Price],[BasePrice1]*[QTY], [Custom Price]*[QTY])
as the ControlSource property of "Total Base Price" instead of =[BasePrice1]*[QTY]

THANK YOU VERY MUCH. That did the trick.

[Bob Fitz]

THANK YOU VERY MUCH. That did the trick.

Glad it worked for you

Just curious. Why aren't QTY and Custom Price bound to a field in the forms Record Source?

[mindbender]

Glad it worked for you

Just curious. Why aren't QTY and Custom Price bound to a field in the forms Record Source?

Every field is unbound as they are calculated from custom control sources and none of the data is saved. It is a margin calculator so they data stays populated untitl they either close the database or hit the refresh button