Copy fields data

[diensatthan]

HELP!

I set up a hazardous material table named tblReceivals with the following fields: MaterialName, QtyReceived, QtyDisposed, QtyRemained, etc.

I also set up a data entry form named frmReceivals where the user can populate the QtyReceived field for adding a new record. The QtyRemained field is not on this form.

How can I assign the input QtyReceived value to the QtyRemained value (these two fields should have the same values) in a new added record, using a frmReceivals event procedure?

THANKS!

 

[DES]

Well first of all I don't think you should be storing a value that you can calculate later. Saving the QtyRemained in the table will increase the size of the database needlessly. Taking the total QtyReceived and subtracting the total QtyDisposed for any one MaterialName will always give you the QtyRemained.