If the form is used to enter or change one or both values (Quantity and Weight), keep the computation at the form level:
Private Sub Quantity_AfterUpdate()
Private Sub Weight_AfterUpdate()
Private Sub ComputeTotalWeight()
Me.TotalWeight.Value = Me.Quantity.Value * Me.Weight.Value
Normally TotalWeight should not be stored in any table. It's a derived value that can be computed from two other values.
Another Postcode problem (combobox cant handle all of them)
Ok, so i have about 135,000 postcodes in my database now, in the PostcodesTBL table,
the reason its in the table and not on a datalink from excel is because when trying the link to excel it instantly made access so slow, and it crashed.. but with the postcodes in the table in access, it seems to handle it fine.. however,
on my form, i have the combobox that gets the data from postcodesTBL, and stores it in StockTrackerTBL when the record is complete and saved, however, when you click the dropdown box, it can only handle a certain amount in the list, when i type in "SE18" and look for it in the list, it isnt there, and when i enter a full postcode like SE18 7NN, it says its not in the list and can't store that value..
is there a workaround for this that i'm not thinking about? like having a text box that will relate to the PostcodesTBL and just typing the postcode in the Text box will recognise that SE18 is in the Massive list?