How to display a value of one field into another field

[ManuelLavesa]

Hello all, this is what I am trying to accomplish, I have a Purchase Order Receiving Form. In that form there are two fields, one is "QtyPurchased" and the other is "QtyReceived". And I would like it to have them display the same value because for most orders the QtyPurchased should equal the QtyReceived. But the difference is that for QtyPurchased is on the table PurchaseOrders from when I made the purchase Order, And for QtyReceived I want the value displayed but not saved on the table as it is not received yet, and I should be able to modify it if the qty Received is less than the Qty Purchased. Then when I press enter in the QtyReceived Field I would like the value to be saved on the table PurchaseOrders and added to the inventory.


Could you please give me any ideas of how to accomplish this. Thank you for your help.

[June7]

QtyReceived field is also in PurchaseOrders table? So at what point do you want to populate this field - when the order record is created?

[ManuelLavesa]

Yes that field is also in the PurchaseOrders Table. I want to populate the field once the Purchase order is received, not while we are waiting for the products to arrive. So first we make the Purchase Order. The field QtyPurchased is populated, and the purchase order is sent to the supplier. Then once we get the products I open another form for receiving, and is in this form that we want to populate the QtyReceived field. The way I have it now that quantity is 0, and we have to input the quantity all the time, and most often is the same as the qtyPurchased. So I would like to make it so that the default value of QtyRecieved is = to QtyPurchased. But only after It is received.

[June7]

Options:

1. assuming the form is opened filtered to specific order record you want to edit, code in form Current event can immediately set value:

If IsNull(Me!QtyReceived) Then Me!QtyReceived = Me!QtyPurchased

2. that same code behind a button

[ManuelLavesa]

Yes the form is opened filtered to the purchase order. I tried what you suggested but it is not working. Meaning the qtyReceived is still =0. The fields are in a subform and I tried putting it directly into the subform, and in the main form and still it does not seem to work. Thank you for the code...

[June7]

Code needs to be behind form that has the fields.

If you want to provide db for analysis, follow instructions at bottom of my post.