K
Kenny Kepler
Hi,
I have a rather strange thing happening on my DB. I have created a subform
adding details relating to orders. The PRICE control is calculated by
multiplying the UNIT_PRICE and two other controls' values. The UNIT_PRICE
is taken from a query and is part of the source table. The other two
contols and the PRICE control are part of the subform and it's source table.
No what is the desired result is to have a default value of blank for the
two controls on the subform and have a default vaule of 0 for the PRICE
control. If I create a default value for PRICE and I don't create on for
the other two controls on the subform I get told "Field Cannot be updated"
and I see Error# in the price control as soon as I start entering data into
those two control's. I can funnily enough still enter data into the the
controls after clicking OK to the error message "Field Cannot be updated".
Although this is only a cosmetic problem I would really like to be rid of
it. If I don't set a value for the PRICE field then I don't get the pop-up
error message but I still have the Error# value in the PRICE control until I
finish entering data into all the fields that require an entry for the
formula that generates the value for PRICE. Is there a way for me to have
the default value for PRICE to be set to 0 and for it to stay like that till
the other two fields have been updated?
TIA,
Kenny
I have a rather strange thing happening on my DB. I have created a subform
adding details relating to orders. The PRICE control is calculated by
multiplying the UNIT_PRICE and two other controls' values. The UNIT_PRICE
is taken from a query and is part of the source table. The other two
contols and the PRICE control are part of the subform and it's source table.
No what is the desired result is to have a default value of blank for the
two controls on the subform and have a default vaule of 0 for the PRICE
control. If I create a default value for PRICE and I don't create on for
the other two controls on the subform I get told "Field Cannot be updated"
and I see Error# in the price control as soon as I start entering data into
those two control's. I can funnily enough still enter data into the the
controls after clicking OK to the error message "Field Cannot be updated".
Although this is only a cosmetic problem I would really like to be rid of
it. If I don't set a value for the PRICE field then I don't get the pop-up
error message but I still have the Error# value in the PRICE control until I
finish entering data into all the fields that require an entry for the
formula that generates the value for PRICE. Is there a way for me to have
the default value for PRICE to be set to 0 and for it to stay like that till
the other two fields have been updated?
TIA,
Kenny