Please look at my simple Access 2000 business database: http://www.bestsharing.com/files/6YcsupN277234/chem.mdb.html
On the form named "Chemical In"...
...this is where someone enters the amount of product they are purchasing along with the purchase date. At the moment, the form also expects them to manually enter the "price per unit" of the chosen item as well as the summative "purchase cost".
This is silly when "price per unit" is obtainable from the "Chemical List" table, and the purchase cost would simply be price per unit * amount.
To prevent the inevitable eventual human error, I want to make those last two fields on this form to self update. They are only there to inform the user how much the cost is going to be as they key in the amount.
...but how do I do the auto updating bit? I've tried linking the textboxes to their respective fields, but they don't seem to cooperate (I just get #name whenever I try). Can someone please look at my database and tell me how to set the auto-updating fields up?
On the form named "Chemical In"...
...this is where someone enters the amount of product they are purchasing along with the purchase date. At the moment, the form also expects them to manually enter the "price per unit" of the chosen item as well as the summative "purchase cost".
This is silly when "price per unit" is obtainable from the "Chemical List" table, and the purchase cost would simply be price per unit * amount.
To prevent the inevitable eventual human error, I want to make those last two fields on this form to self update. They are only there to inform the user how much the cost is going to be as they key in the amount.
...but how do I do the auto updating bit? I've tried linking the textboxes to their respective fields, but they don't seem to cooperate (I just get #name whenever I try). Can someone please look at my database and tell me how to set the auto-updating fields up?
