good day i created a database with the following information:
tblrecords
field1 Produnt
field2 Amount
field3 Discount
field4 Total
and i make a query of my table then create a from base on the query...
my problem is in the total field in the FORM is not working...
the total should automatically update when you put any amount in the Amount and in the Discount field..
for example you put 5 in amount and 2 in discount automatically the total will add a value of 3...
anyone can help me in this problem....
thank you...
tblrecords
field1 Produnt
field2 Amount
field3 Discount
field4 Total
and i make a query of my table then create a from base on the query...
my problem is in the total field in the FORM is not working...
the total should automatically update when you put any amount in the Amount and in the Discount field..
for example you put 5 in amount and 2 in discount automatically the total will add a value of 3...
anyone can help me in this problem....
thank you...
Attachments
Last edited: