Shouldn't linking a form to it's table be easy?

[sanj]

This problem has been bugging me for a whole week, and I would be eternally grateful if anyone can help solve it:

I have a form where customers can order a variety of products. The forms' underlying table is called TableCustomers and stores (almost) all the information inputted in its respective form. I have three fields in the form that display the sub total, VAT (tax) and Total (an addition of Sub Total and VAT)

These three fields are calculated by using simple formulas, by pulling information from other areas. For instance, if a customer chose a particular wine from a drop down box, the cost of that wine would be 'sent' to the running sub total (i.e: =Text97). Due to all the calculations being performed on the form, the final totals for some reason will not save to Table Customers, whilst everything else (such as customer details) will. What am I doing wrong? Should I give up the computing degree? Is Access not so accessible?

Thanks in advance

 

[Kensan]

The [final total] field has to be on your form in order for it to go to the table. What you should do is calculate this amount, perhaps in the AfterUpdate event of your list box then assign this value to the [final total] field, ie

[final total] = [VAT] + [Sub Total]

I'm assuming that [final total] applies to the current record and is not a grand total for the whole order.

If your concerned about a grand total then you dont have to store this. If each order has a unique number you can create a grand total for any order from the [final total] for each item in the order.

Hope this Helps

Yes Access can be a bit inaccessible, but keep at it, by doing - and hair pulling - we learn.

Goodluck