Hi,
Am new to this forum and also a beginner in Access. I don't have an IT background and I have learnt Access VBA on my own.
I am creating an Inventory management tool using Access. I have created 2 forms:
1. Purchase Order ([ProductID], [Brand], [Quantity], [UnitPrice], [Total])
2. Inbound Item ([ProductID], [Brand], [Quantity], [UnitPrice], [InOutQty],[Status],[Note])
when the user fill in a purchase order, the information is duplicated in an Inbound Item form. In addition, there is a field called [InOutQty]. It is supposed to be the quantity that has been confirmed from the supplier but not yet in stock. Currently, this field has to be filled manually. I would like this field to have the same value as the field [Quantity].
I have tried defaultValue = [Quantity] but it doesn't work.
I have tried using VBA subform_AfterUpdate [InOutQty].value = [Quantity].value and it doesn't work neither.
Can someone help me on that matter?
Thank you