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" wrote:
[Quoted Text] > 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" <zordanj[ at ]discussions.microsoft.com> wrote in message
> news:BC80AC2E-1C93-4DF7-89C1-A9728ED12706[ at ]microsoft.com...
> > 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.
>
>
>
|