My database is simple. It has a table that tracks customers, with they're name, address, etc.
I have a price list table that contains "iteminstall" , "price", and "qty"
and I have a payment table that trackes date, and payment amount.
I have a subform, with the field (textbox) "price." I have it auto populate when I type in something under (combobox) "iteminstall". This is a recent addition. I used to have to type it manually.
In the subform, "iteminstall" is a combo box, and price is a text box.
In the footer of the subform, I have the expression:
=Sum([price]*[qty]).
On the main form I have a text box that links to this field, to display a subtotal. Now the price is autopopulating in the subform, but it is not changing my subtotal. This only started happening when I set "price" to autopopulate. The existing subtotal is still there, but If I add anything to the order, it won't update the subtotal. Instead, it continues to display the old subtotal.
I added a new record, and tried entering some new data, but subtotal is outputing "0" on all new records. Any Ideas?