Hello

  • Thread starter Thread starter zordanj
  • Start date Start date
Z

zordanj

Hello,
I have a data entry form. I want to see if someone enters unit and amount in
the data entry form. the calculation should be done automatically in the
total amount field in the data entry form. Please let me know how it is
possible.
 
Hi zordanj

Set the ControlSource of your TotalAmount textbox to:
=[unit] * [amount]

Better still, create a query based on your table and include in it all the
fields from your table and also a calculated field:
TotalAmount: [unit] * [amount]

Then you can bind your textbox to this calculated field.
 
Hello Graham Mandeno,
It really hepled me. Thanks a lot. That was easy for you but was hard for
me.lolz. Thank you once again.

Graham Mandeno said:
Hi zordanj

Set the ControlSource of your TotalAmount textbox to:
=[unit] * [amount]

Better still, create a query based on your table and include in it all the
fields from your table and also a calculated field:
TotalAmount: [unit] * [amount]

Then you can bind your textbox to this calculated field.
--
Good Luck :-)

Graham Mandeno [Access MVP]
Auckland, New Zealand

zordanj said:
Hello,
I have a data entry form. I want to see if someone enters unit and amount
in
the data entry form. the calculation should be done automatically in the
total amount field in the data entry form. Please let me know how it is
possible.
Click to expand...
Click to expand...
 
Back
Top