adding fields together

[toddbingham]

Have a form with to text box feilds, option1 and option2. When values are manually entered into them, want it to add then together and place to total amount into a total field the is part of table1.
How do I do that?

 

[Lol Owen]

Okay, I'm fairly new to the forum and Access, but I had a similar problem recently. Mine involved criteria where if an order quantity was reached then discounts were applied. i found this easier to build as a calculated control on the form using VBA. I guess it depends on your knowledge of VBA or SQL.

Cheers, Lol

 

[Lol Owen]

Thats where i put mine, in the AfterUpdate part. Works great. However, I must say I'm more exzperienced with VB than Access, that's why I chose this route.

Lol