I have created two forms sale and purchase .in purchase form I have two text boxes cost per item1 and cost per item2. I need to store these inputs cost per item1 and cost per item2 in ms access table then when I use sale form to enter sale data’s (I have two text boxes quantity sold1 and quantity sold2) and click on save button, I want to get the total cost of both unit sold such as (cost per item1*unit sold1) + (cost per item2*unit sold2)
I can do it using Vb.net and excel but I don’t know how to deal with it in ms access. Any bit of info would be helpful.
Categorized | Affiliate Marketing 101
Help With Vb.net And Ms Access?
Posted on June 19, 2012.
The quickest way is to put them directly on to your form as text boxes. In form design, drag two new textboxes on to the form. Against Properties – Control source put
=[cost per item1]*[unit sold1]
=[cost per item2]*[unit sold2]
I’m assuming that these are the names of four real fields in your underlying table or query.